I implemented faceted search on my own blog entirely on top of PostgreSQL. It works well, but that's because my blog has only 11,348 documents total.
Notes on how I built that here: https://simonwillison.net/2017/Oct/5/django-postgresql-facet...
Notes on how I built that here: https://simonwillison.net/2017/Oct/5/django-postgresql-facet...