News for hackers. Stuff that matters.
Re:Do We Still Have to Denormalize? Have Your Schema and Sea... by oulipo on Monday November 16, 2026 @04:50AM (#50515806)
In my case I'm not so much interested by the BM25 aspect (I don't really have text to search), but I have collection of objects with many columns (having a small-ish number of values, et categories/tags) and I'd like to have an easy way to facet-filter them efficiently.

Right now with "vanilla Postgres" I have to guess which combination of facets is going to be common and try to define indexes for these. Would ParadeDB help there?

Re:Do We Still Have to Denormalize? Have Your Schema and Sea... by stuhood on Monday November 16, 2026 @11:13AM (#50519230)
Yes, I believe that it would.

It sounds like you are in a similar boat to https://www.paradedb.com/customers/moderntreasury: no BM25 scoring, but a need to filter, sort, and aggregate by a variety of columns.

Re:Do We Still Have to Denormalize? Have Your Schema and Sea... by oulipo on Monday November 16, 2026 @01:45PM (#50521231)
Interesting! I'm using a custom image (because I'm using timescaledb too), can I just add the extra paradedb extension to my image and it will work for normal postgres tables (I assume I can't add a paradedb index on a timescale hypertable?)