hn.today

Postgres 19 is out, and it's available on Neon and Databricks Lakebase

databricks.com63 points22 comments
Screenshot of Postgres 19 is out, and it's available on Neon and Databricks Lakebase

PostgreSQL 19 is presented as a practical, operations-focused release, available on Neon and Databricks Lakebase at launch. Rather than changing PostgreSQL’s overall character, it adds tools for recurring production problems: table bloat, unstable query plans, replica lag, and difficult maintenance. A central addition is REPACK, which can reclaim space and optionally cluster rows by an index while reads and writes continue through most of the rebuild. Unlike VACUUM FULL or CLUSTER, it avoids blocking access for the full operation, but it needs extra disk space and a replication slot, and its brief final exclusive lock can be delayed by long-running transactions. The release also adds query-plan advice, allowing teams to inspect planner decisions, test adjustments, and store advice by query ID without changing application SQL.

Other changes improve maintenance and diagnosis. Autovacuum can use parallel workers for indexes and prioritizes tables with a new scoring system; new statistics views expose lock, recovery, and autovacuum activity. EXPLAIN and logging can report asynchronous I/O, while WAL reporting adds full-page-image byte counts. PostgreSQL 19 also introduces WAIT FOR LSN for read-your-writes consistency on replicas and expands logical replication capabilities. The announcement stresses that plan advice should stabilize a known problem, not replace the optimizer, and that REPACK CONCURRENTLY has important constraints, including a limit on updates and deletes during the operation and possible stale-snapshot issues. Lakebase engineers contributed directly to the PostgreSQL release.

Read on databricks.com22 comments on Hacker News

Summary generated by AI from the linked article. hn.today is not affiliated with Hacker News or Y Combinator.

More in Programming

The daily digest

Today's best Hacker News stories, summarized and screenshotted, one email a day.