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