Postgres recovery_prefetch Considered Harmful and Causing Outages
Summary
A detailed look at how PostgreSQL recovery_prefetch can trigger outages by amplifying read IOPS during synchronous replication. The post documents field observations and reproducible test steps, explains the underlying standby state machine and WAL flow, and discusses potential mitigation by disabling recovery_prefetch.