Code RoomCheckpoint latency spikes
HardPrep Room Coding #2775

Checkpoint latency spikes

On-callDatabases & SQLReliability & on-callSenior–Staff~35 min

Your write-heavy Postgres primary shows a regular, painful pattern: every few minutes write latency p99 spikes from 5ms to 400ms for 20–30 seconds, then recovers, like clockwork. During each spike, disk write I/O and `iowait` jump, and the logs show frequent checkpoint activity with `checkpoints are occurring too frequently`. Traffic is steady — the spikes don't line up with traffic, they line up with each other at a fixed interval. The instance has plenty of CPU. Triage and mitigate.

What a strong answer looks like

Stop the bleeding first (mitigate), then form hypotheses from real signals. Separate root cause from symptom, communicate status as you go, and close with what prevents a repeat.

0:00 of about 35 min
Which questions mattered is sealed until you submit. Telling you now would just be handing over the edge cases.