Checkpoint (PostgreSQL)

From ben.goodacre.name/tech

Jump to: navigation, search

Checkpoint flushes all buffers to disk and deletes xlogs

Settings

checkpoint_timeout: Maximum allowed time since the last checkpoint. checkpoint_completion_target: Target length of the checkpoint. Instead of using all possible I/O in a short time it is spread across the target value to avoid high spikes in I/O, the value is checkpoint_completion_target * checkpoint_timeout checkpoint_segments: When xlogs hit this qty a checkpoint is triggered.

Most CPs should be due to timeout.

See Also

Personal tools
Namespaces
Variants
Actions
Navigation
Toolbox