PostgreSQL version:

checkpoint_completion_target

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