Wiki / Configuration Parameters

Specifies the target of checkpoint completion, as a fraction of total time between checkpoints. The default is 0.9, which spreads the checkpoint across almost all of the available interval, providing fairly consistent I/O load while also leaving some time for checkpoint completion overhead. Reducing this parameter is not recommended because it causes the checkpoint to complete faster. This results in a higher rate of I/O during the checkpoint followed by a period of less I/O between the checkpoint completion and the next scheduled checkpoint. This parameter can only be set in the postgresql.conf file or on the server command line.

English manual coverage begins with PostgreSQL 7.4. Source history and runtime observations have their own recorded version boundaries.

boot val

0.9

category

Write-Ahead Log / Checkpoints

context

sighup

documented

true

enumvals

Unknown

extra desc

Unknown

lang

en

max val

1

metadata version

18

min val

0

name

checkpoint_completion_target

short desc

Time spent flushing dirty buffers during checkpoint, as fraction of checkpoint interval.

source

pg-settings-source-snapshot

unit

Unknown

vartype

real