Change checkpoint_completion_target default to 0.9
authorStephen Frost <sfrost@snowman.net>
Wed, 24 Mar 2021 17:07:51 +0000 (13:07 -0400)
committerStephen Frost <sfrost@snowman.net>
Wed, 24 Mar 2021 17:07:51 +0000 (13:07 -0400)
commitbbcc4eb2e08fb6e4535c7f84b2c00f3ad508bb9b
tree64b67f0b4ba21b9ac6496b6f3f21c1e456a77920
parente5595de03ec6ce60afde980ae05e9353a1501fdf
Change checkpoint_completion_target default to 0.9

Common recommendations are that the checkpoint should be spread out as
much as possible, provided we avoid having it take too long.  This
change updates the default to 0.9 (from 0.5) to match that
recommendation.

There was some debate about possibly removing the option entirely but it
seems there may be some corner-cases where having it set much lower to
try to force the checkpoint to be as fast as possible could result in
fewer periods of time of reduced performance due to kernel flushing.
General agreement is that the "spread more" is the preferred approach
though and those who need to tune away from that value are much less
common.

Reviewed-By: Michael Paquier, Peter Eisentraut, Tom Lane, David Steele,
Nathan Bossart
Discussion: https://postgr.es/m/20201207175329.GM16415%40tamriel.snowman.net
doc/src/sgml/config.sgml
doc/src/sgml/wal.sgml
src/backend/postmaster/checkpointer.c
src/backend/utils/misc/guc.c
src/backend/utils/misc/postgresql.conf.sample
src/test/recovery/t/015_promotion_pages.pl