This has been lying around in my drafts for a while.
#postgres 19 finally has an answer to the previously janky workflow for performing read-after-write. #MySQL has had this feature forever, but "WAIT FOR LSN" solves it in PG land.
Took a while to write this one.
rednafi.com/system/wait-...
PostgreSQL 19's new WAIT FOR LSN command lets a replica block until it has replayed your write. The read-after-write problem it solves, the workarounds it replaces, and what the timeout, status, and m...
