PostgreSQL 19's WAIT FOR LSN command replaces the read-your-writes polling loop

I tested PostgreSQL 19 beta 4's new WAIT FOR LSN command against the polling loop it replaces: matched latency against a tight poll, but 38% mean standby CPU against 57% under 10 concurrent readers, plus the exact errors it throws for every misuse I tried.

Read the full article at dev.to →