Toggle navigation

checkpoint_completion_target

Type: real
Default: 0.5
Min: 0
Max: 1
Context: sighup
Restart: false

Specifies the target of checkpoint completion, as a fraction of total time between checkpoints. The default is 0.5. This parameter can only be set in the postgresql.conf file or on the server command line.

Recommendations

Defines the fraction of one checkpoint_interval over which to spread checkpoints. The default value works for most users.

Comments