News for hackers. Stuff that matters.
Re:Do We Still Have to Denormalize? Have Your Schema and Sea... by jamesgresql on Sunday November 15, 2026 @10:37PM (#50513732)
Any questions please go for it, ParadeDB team is watching.
Re:Do We Still Have to Denormalize? Have Your Schema and Sea... by nehalem on Monday November 16, 2026 @03:15AM (#50515257)
I would like to try out ParadeDB and potentially retire Typesense but being unable to install it in CloudSQL makes it more than difficult.
Re:Do We Still Have to Denormalize? Have Your Schema and Sea... by sorenbs on Monday November 16, 2026 @08:44AM (#50517535)
[delayed]
Re:Do We Still Have to Denormalize? Have Your Schema and Sea... by isaacvando on Monday November 16, 2026 @09:50AM (#50518196)
If you want to stay on CloudSQL, you can always setup a ParadeDB cluster as a logical replica. Our cloud offering is in private preview if you'd like to try: https://app.paradedb.com
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?)