[emilsedgh]

This looks very neat. In our company, for the past 10 years I've bet heavily on Postgres have not allowed any other databases to be used. Stuff like this makes me hope I can continue to do so as our database is growing.

But, it appears that we are hitting our limits at this point. We have a table with tens of millions of rows and the use case is that it's faceted search.

Something like Zillow, with tends of millions of listings and tens of columns that can be queried. I'm having a tough time scaling it up. Does anyone have experience building something like that in pg?

[patrickhogan1]

pg_bm25 - Optimized for faceted search & PGroonga - Full-text search with JSONB support

[crowdyriver]

Unrelated, but PGroonga reads funny in Argentinian. Better than gimp though

[pezezin]

I read your comment with El Bananero's voice and now I can't stop laughing xD