Back in October I wrote that PostgreSQL 19 was running late, partly because developers were swamped by AI-generated bug reports and security issues. It shipped today, Phoronix reports.
PostgreSQL 19.0 brings parallel workers for vacuuming indexes in autovacuum, better queries on foreign tables, INSERT ... ON CONFLICT DO SELECT, faster foreign key checks, automatic tuning of the number of I/O workers in the default “worker” I/O method, server-side SNI support, and logical replication of sequence values. One change to note: JIT compilation is now disabled by default because its cost estimates were considered unreliable. If you run lots of big analytical queries, you may want to turn it back on.
My take
Worth the wait. Don’t jump a production cluster to a new major on day one, though. Test your upgrade with pg_upgrade --check on a copy first, and re-check query plans if you leaned on JIT.
Review before you install: read the release notes yourself, back up your config, and try new versions somewhere you can afford to break first.
God Bless, and Happy hacking!