Wiki / 配置参数

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.

英文手册覆盖始于 PostgreSQL 7.4. 来源历史与运行验证各自保留独立版本边界。

此版本暂无所选语言的定义，以下显示原始英文内容。

boot val

0.9

category

Write-Ahead Log / Checkpoints

context

sighup

documented

true

enumvals

未知

extra desc

未知

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

未知

vartype

real