Databases · Senior · Question 69 of 75
Right after a database failover, latency spikes even though the new primary has the same hardware. What's a likely cause?
- ✓Correct answer: A cold cache: the new primary's memory doesn't yet hold the hot data, so queries hit disk until it warms up
- 2Failover disables query planning
- 3Indexes are dropped during failover
Explanation
Replicas serving reads stay warmer. Extensions like pg_prewarm can load important tables and indexes into memory ahead of time.