PostgreSQL 19 Ships WAIT FOR LSN, Solving Read-Your-Writes on Replicas

Simon Willison · rss · 2026-11-20

Simon Willison covers the PostgreSQL 19 release, which slipped two months past its usual September slot largely due to the wave of AI-reported vulnerabilities the team had to address.

The standout feature is the new WAIT FOR LSN command, providing read-your-writes consistency for read replicas:

Willison notes the pattern echoes Wikipedia's hand-rolled MySQL replication solution in MediaWiki (WAITFOREXECUTEDGTIDSET / MASTERPOSWAIT), now native in Postgres.

Original post →

More from Infra

Infra channel →