PostgreSQL 19 beta WAIT FOR LSN lets a replica session wait until changes through a target log position have replayed. A following read can then see writes through that position.
In the demo, the read gate opens when the replica reaches LSN 104. This is still a beta feature; check the stable release and its wait and timeout behavior before production use.
When to use
Evaluate it as a beta feature for read-your-writes flows on a replica.