Read your writes: WAIT FOR in PostgreSQL 19

PostgreSQL 19's new `WAIT FOR` command enables read-your-writes consistency on asynchronous replicas by letting individual reads wait for a specific WAL position.

Sources

Read your writes: WAIT FOR in PostgreSQL 19 · TechNews