Skip to content
Simon Willison·· 3 h agoAI score32

PostgreSQL 19 Released with WAIT FOR LSN for Read-Your-Writes Consistency

PostgreSQL 19 Released

AI summary

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.

Source:Simon Willison · simonwillison.net