PostgreSQL 19 introduces WAIT FOR, a new SQL command that blocks a session until WAL reaches a specified position, enabling read-your-writes consistency on asynchronous replicas without the performance cost of synchronous replication. The command solves the stale read problem by allowing applications to wait for specific WAL positions before reading from standby databases.