Stop Punishing Your Postgres for a Crash That Won't Happen (opens in new tab)

There is a misconception I keep running into, and it causes real harm in production. People are afraid to increase checkpoint_timeout. They think a longer timeout means a longer recovery after a crash. So they set it to 5 minutes. Some set it to 1 minute. And then they wonder why their Postgres is struggling. Let me dismantle this fear, argument by argument. First: serious people have a replica 🔗If you care about availability, you have at least one replica you can fail over to.