PostgreSQL 19 Released
7.9 relevance
Score Breakdown
technical depth 8
novelty 9
actionability 7
community 8
strategic 7
personal 8
Scored daily by a customisable AI persona to surface the most relevant engineering leadership news.
PostgreSQL 19 release is a major database event with new features, highly relevant to data engineering and infrastructure.
Summary
PostgreSQL 19 introduces REPACK (CONCURRENTLY) for online table bloat removal without blocking reads or writes, replacing VACUUM FULL and CLUSTER. The new pg_plan_advice extension stabilizes query plans and allows experimentation via a mini-language, while autovacuum gains parallel index workers and a scoring system for prioritization. Logical replication no longer requires server restarts, as the effective WAL level auto-escalates to logical when the first slot is created.
Author
PostgreSQL Global Development Group