checkpoint

This tag is associated with 2 posts

Postgres Checkpoint Followup and Collation Visualization and Codex Luna

Posted by Jeremy ⋅ August 12, 2026 ⋅ Leave a comment

My previous article talked about the checkpoint happiness hint: You probably should not change the checkpoint_timeout setting from its default of 5 minutes. Checkpoint Followup Questions A good follow-up question was raised: can an HA replica can save you from downtime if you want to set a large checkpoint_timeout? It’s true that Postgres allows promoting … Continue reading →

Happiness Hint: Alarm on Checkpoint Time

Posted by Jeremy ⋅ June 24, 2026 ⋅ 2 Comments

Before starting, I want to put a few things at the top: Checkpoint is the heart of your database. It’s buried deep inside. It’s not something everyone talks about, like well-tuned autovacuum or fast queries. But if checkpointer stops beating, then you’re dead. In addition to its well-understood job of getting dirty pages written from … Continue reading →