Overview
- PostgreSQL 19 reached general availability on Thursday, November 19, and Databricks made the new release available on Lakebase the same day for customers to try.
- The release adds REPACK, a core command that reclaims disk space and can run CONCURRENTLY to rebuild tables with minimal read/write blocking, but it requires extra disk space and uses a temporary replication slot during the operation.
- Two new extensions, pg_plan_advice and pg_stash_advice, let DBAs describe, test, store, and automatically apply planner guidance for specific queries so they can stabilize or alter plan choices when statistics are insufficient.
- Replication and standby coordination were improved with the ability to enable logical decoding without a restart, sequence synchronization for subscribers, and a WAIT FOR LSN command that lets a standby block until it has replayed a specific WAL position to achieve read‑your‑writes behavior.
- Administrators are advised to stage test upgrades because 19 changes defaults and compatibility (for example JIT off by default, TOAST compression set to lz4, removal of RADIUS) and some development features were reverted before release; many teams expect to wait for the first minor patch, 19.1, anticipated in February.