Omarchy

Update: PostgreSQL 19 Is Finally Out, With JIT Off by Default

Leave a comment

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!

References & Further Reading

Subscribe (RSS) Follow News via RSS

Leave a note

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.