- New REPACK command reclaims disk space and reorganizes tables, with CONCURRENTLY avoiding read/write blocking
- pg_plan_advice and pg_stash_advice extensions control and auto-apply planner advice
- Logical replication gains restart-free enablement, sequence-value replication, and standby read-your-writes consistency
AI CURATED HOT STORY · 11/20/2026
PostgreSQL 19 Released with WAIT FOR LSN for Read-Your-Writes Consistency
PostgreSQL 19 has been officially released, two months later than usual, primarily because the team needed to address a surge in security reports from AI-assisted vulnerability discovery. The most anticipated feature is the WAIT FOR LSN command, which allows a standby session to wait until WAL replay reaches a specified LSN before executing queries, enabling read-your-writes consistency in read-write splitting architectures. Applications can use the return value of pg_current_wal_insert_lsn() (e.g., stored in a signed cookie) for subsequent consistency waits.
Beyond consistency reads, PostgreSQL 19 focuses on operational control, introducing online REPACK (with CONCURRENTLY mode not blocking reads/writes), pg_plan_advice and pg_stash_advice extensions for query plan intervention, and enhanced logical replication with no-restart enablement, sequence value replication, and standby read-your-writes. Databricks Lakebase provided same-day support, breaking the usual weeks-long lag for managed services, with multiple PostgreSQL committers on its team directly involved in core development.
These updates significantly reduce application complexity in read-write splitting architectures and improve database operational flexibility and efficiency. WAIT FOR LSN is poised to become a key tool for building highly consistent distributed systems, while online REPACK and query plan advice further ease the daily burden on DBAs. The release also reflects the tangible impact of AI-assisted security research on open-source software maintenance cadence.
Hourly heat curve
12 fully observed hoursThe line compares only sources observed throughout; gap hours are interpolated to keep the trend continuous.
Coverage timeline
Total 3 reports · Latest first- Hacker News AIT2·58 pts
- Hacker News AIT2·58 pts
- PostgreSQL 19 emphasizes operational control: online REPACK, query plan advice, and WAIT FOR LSN replica consistency
- Lakebase offers same-day GA support, breaking the usual weeks-long managed-service lag
- Multiple Lakebase engineers are PostgreSQL committers who contributed directly to the release
- Simon Willison 博客T2·58 pts
- WAIT FOR LSN lets a standby wait for WAL replay up to a target LSN, solving read-your-writes on read replicas
- The release slipped two months as the team handled a surge of AI-assisted vulnerability reports
- Apps can persist pg_current_wal_insert_lsn() output (e.g. in a signed cookie) and use it for consistency waits on later requests