checkpoint_timeout

A configuration parameter defining the maximum time between checkpoints.

checkpoint_timeout is a configuration parameter defining the maximum time between automatic WAL checkpoints.

checkpoint_timeout was added in PostgreSQL 7.1.

Default value

The default value for checkpoint_timeout is: 5min.

Log output

As of PostgreSQL 13. even when log_checkpoints is set to on, there is no indication in the log output that a checkpoint occurred due to the time limit set by checkpoint_timeout being exceeded.

Change history

Categories

GUC configuration item, Performance, WAL

See also

max_wal_size, min_wal_size, checkpoint_warning, checkpoint_flush_after