checkpoint_completion_target was added in PostgreSQL 8.3.
checkpoint_completion_target influences the "intensity" of I/O operations performed during a checkpoint. The more these can be spread out, the less risk there is of an I/O spike; consequently for a long time the general recommendation has been to set
0.9 (the default from PostgreSQL 14) rather than the original default of
The default value for