3 ms·
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
by emilsedgh 2y ago
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 2y agopg_bm25 - Optimized for faceted search & PGroonga - Full-text search with JSONB support
- crowdyriver 2y agoUnrelated, but PGroonga reads funny in Argentinian. Better than gimp though
- pezezin 2y agoI read your comment with El Bananero's voice and now I can't stop laughing xD