Skip to content
Live
Trending storyDeveloping

PostgreSQL 19 Released

1 reports1 outlets3 hours agoUpdate

The story so far

AI overview

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

Latest20 Nov, 04:43
PostgreSQL 19 Released

Coverage timeline

Follow the coverage to see every side of the story.

20 Nov
  1. Simon Willison
    PostgreSQL 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.