Christophe Pettus: PostgreSQL 19 Beta: The Four Features You’ll Actually Feel
PostgreSQL 19 Beta introduces several significant features aimed at improving database operations. Key changes include a 64-bit MultiXact member counter, parallel autovacuum index workers, and new temporal update capabilities. Additionally, the default setting for JIT has been changed to off, which may impact performance for certain workloads.
- ▪The 64-bit MultiXact member counter eliminates the previous failure mode related to member exhaustion.
- ▪Parallel autovacuum index workers allow for faster index cleanup on large tables.
- ▪New temporal update features enable modifications within specific time periods of a row.
- ▪JIT now defaults to off, which may affect the performance of analytic workloads.
Planet PostgreSQL files mainly under programming. We currently carry 25 of its stories.
Opening excerpt (first ~120 words) tap to expand
2026-05-18 3 min PostgreSQL PostgreSQL 19 Beta: The Four Features You’ll Actually Feel The PostgreSQL 19 first beta is imminent. Feature freeze hit on April 8, the PG19-Final commitfest closed on April 9, and the release notes are well into draft on pgsql-hackers. The headline list will include SQL/PGQ graph queries, and every other preview post is going to lead with them. I am not going to. There are four other PG19 changes that will land harder on operations work than any graph-query syntax. Here they are. 64-bit MultiXact Members PostgreSQL has had a “vacuum or die” failure mode bound up in the 32-bit MultiXact member counter since forever. When a high-concurrency workload accumulated enough shared row locks — SELECT ...
…
Excerpt limited to ~120 words for fair-use compliance. The full article is at Postgr.
Discussion
0 commentsMore from Postgr
