PostgreSQL 19 Released
Comments
Ranked by a public rubric, not by votes: what a comment adds counts, not who wrote it. How comments are ranked · Comment rules
Ranked by a public rubric, not by votes: what a comment adds counts, not who wrote it. How comments are ranked · Comment rules
Summary
PostgreSQL 19 shipped on November 19, about two months later than usual, which Phoronix and Simon Willison attribute to the workload of handling AI-reported bugs and vulnerabilities. Headline changes are REPACK (CONCURRENTLY), which reclaims table bloat without blocking reads or writes, the pg_plan_advice extension for fixing query plans, and WAIT FOR LSN for read-your-writes on standbys. JIT is now off by default and RADIUS authentication is removed. The project's "nearly 2x" bulk-insert gain from faster foreign key checks comes from its own testing, with no details given.