Do We Still Have to Denormalize? Have Your Schema and Search It Too

ParadeDB's Stu Hood describes making multi-table search joins fast in Postgres without denormalizing data into an external engine. On the StackOverflow benchmark, a three-table top-K search that took about two minutes in vanilla Postgres runs in roughly 100 ms, using a new Rank Join operator and a DataFusion-based columnar executor.