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
getnobody.hashnode.dev8 min read