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?)
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?