PostgreSQL 19 is released with a new REPACK command that reclaims disk space and reorganizes table contents, with a CONCURRENTLY mode that avoids blocking reads and writes. It also adds the pg_plan_advice and pg_stash_advice extensions for planner control, enables logical replication without a server restart, supports sequence-value replication, and adds read-your-writes consistency on standbys.
PostgreSQL 19
Latest major release of the open-source relational database, focused on online operational control and logical replication enhan
Curated Intelligence
PostgreSQL 19 reached GA and is available on Databricks Lakebase the same day, skipping the usual weeks-long lag for managed services. The release centers on operational control: online REPACK, query plan advice, and WAIT FOR LSN for read-your-writes on replicas, plus logical replication upgrades. Several Lakebase engineers are PostgreSQL committers who contributed directly to the release.
PostgreSQL 19 has shipped roughly two months later than its usual September cadence, largely because the team had to work through a surge of AI-assisted vulnerability reports. The headline feature is the new WAIT FOR LSN command, which lets a standby session wait until WAL replay reaches a given LSN before querying, enabling read-your-writes consistency on read replicas.