News for hackers. Stuff that matters.
Re:Do We Still Have to Denormalize? Have Your Schema and Sea... by philippemnoel on Monday November 16, 2026 @12:19PM (#50520060)
Agreed that people need to iterate on their search index. Our users do this a lot. Postgres has a clause called INDEX CONCURRENTLY, which allows you to build an index in the background while the existing index continues to serve queries.

As for embedding, etc., you can of course do this in Postgres as well. The "T" in ETL can still be done in a Postgres-based product like ParadeDB, but you can have it participate in transactions and avoid denormalizing (or denormalize much less), etc.

Re:Do We Still Have to Denormalize? Have Your Schema and Sea... by philippemnoel on Monday November 16, 2026 @12:33PM (#50520252)
And of course, you can also index expressions to achieve this: https://www.paradedb.com/docs/reference/indexing/indexing-ex...