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.
[ Parent
| on HN ]
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?)