Read your own writes, off the primary
WAIT FOR in PostgreSQL 19 lets a reader block until the replica has replayed a specific LSN. Measured against sticky routing, sleeps, and synchronous commit, on a replica that misses the write 99% of the time.
boringSQL | Supercharge your SQL & PostgreSQL powers ยท Radim Marek
Topics: Databases
Entities: Databases