Skip to content
Hot eventDeveloping

PostgreSQL 19 Released with WAIT FOR LSN

1 reports1 reporting sourcesUpdated 3 h ago

Start here

AI digest

PostgreSQL 19 has been released, about two months later than the usual September schedule. Simon Willison attributes the delay mainly to the volume of vulnerability issues the PostgreSQL team had to address, which he describes as part of an ongoing wave of AI-reported vulnerabilities. The release adds WAIT FOR LSN, which lets a standby session wait until it has replayed the WAL up to a given log sequence number before running a query. This allows applications reading from replicas to see writes just made on the primary. A timeout is optional; if one is set and the replica does not catch up within the specified time, the session raises an error.

Generated from reports · updated 2 h ago

Report timeline

Follow the reports to see the event from different sides.

November 20
  1. Simon Willison
    PostgreSQL 19 Released with WAIT FOR LSN for Read-Your-Writes Consistency

    PostgreSQL 19 has shipped, roughly two months later than the usual September release, after the team worked through a wave of AI-reported vulnerability issues. The release adds WAIT FOR LSN, which lets a standby session wait until it has replayed the WAL up to a given log sequence number before running a query, so applications reading from replicas can see writes just made on the primary. An optional timeout raises an error if the replica does not catch up in time.

Heat for this event

Not enough continuous observations yet to draw a trend.