PostgreSQL 19 Released
The story so far
The PostgreSQL team released the PostgreSQL 19 version, adding a 'read-your-writes' consistency feature. This feature allows standby nodes to wait for replaying the write-ahead log (WAL) to a specified log sequence number (LSN) before executing queries, enabling applications to read data just written to the primary node. This change draws inspiration from Wikipedia's manual version implementation of MySQL partitions, by saving the binary log position of the primary node and waiting for the standby node to synchronize, ensuring users see events in chronological order. This year's release was delayed by two months compared to the usual September, mainly because the team needed to address a series of AI report vulnerability issues.
AI-written from the reports · Updated 2 hours ago
Coverage timeline
Follow the coverage to see every side of the story.
- Simon WillisonPostgreSQL 19 Released
PostgreSQL 19 Released, Adds 'read-your-writes' Consistency Feature, Allows Standby Nodes to Wait for Replication of Write-Ahead Log (WAL) to a Specified Log Sequence Number (LSN) Before Executing Queries, Enabling Applications to Read Data Just Written to the Primary Node. This Feature Draws Inspiration from Wikipedia's Handwritten Version of MySQL Partitions, by Saving the Primary Node's Binary Log Position and Waiting for Standby Node Synchronization to Ensure Users See Events in Chronological Order.
Heat over time
Not enough data yet to draw a trend.