How Postgres 19 checks foreign keys without running SQL
Every time you insert a row into a table with a foreign key, Postgres has to prove the referenced row exists and stop anyone from deleting it until your transaction ends. Up to Postgres 18, it did tha
Sep 24, 20268 min read2