The PostgreSQL Global Development Group has officially released PostgreSQL 19. While typical major versions drop in September, this release was delayed by two months as the team prioritized hardening the codebase against an influx of security vulnerability reports.
The headline feature of PostgreSQL 19 is its native, built-in repack capability. Unlike previous architectures that required third-party tools like pg_repack to recover disk space from dead tuples without blocking read/write traffic, PostgreSQL 19 natively cleans up table and index bloat with minimal lock overhead.
This release also brings noticeable query planner improvements, optimized memory usage for analytical workloads, and streamlined logical replication workflows, making it a compelling upgrade target for database administrators and platform engineers.