Add MODE option to CHECKPOINT command.
authorNathan Bossart <nathan@postgresql.org>
Fri, 11 Jul 2025 16:51:25 +0000 (11:51 -0500)
committerNathan Bossart <nathan@postgresql.org>
Fri, 11 Jul 2025 16:51:25 +0000 (11:51 -0500)
commit2f698d7f4b7b4c49c3649b2fcc063eb66f9d2e6c
tree388d0efadcf8844c59216bf0616f9418b811cba4
parenta4f126516e688736bfed332b44a0c221b8dc118a
Add MODE option to CHECKPOINT command.

This option may be set to FAST (the default) to request the
checkpoint be completed as fast as possible, or SPREAD to request
the checkpoint be spread over a longer interval (based on the
checkpoint-related configuration parameters).  Note that the server
may consolidate the options for concurrently requested checkpoints.
For example, if one session requests a "fast" checkpoint and
another requests a "spread" checkpoint, the server may perform one
"fast" checkpoint.

Author: Christoph Berg <myon@debian.org>
Reviewed-by: Andres Freund <andres@anarazel.de>
Reviewed-by: Fujii Masao <masao.fujii@oss.nttdata.com>
Reviewed-by: Laurenz Albe <laurenz.albe@cybertec.at>
Reviewed-by: Dilip Kumar <dilipbalaut@gmail.com>
Discussion: http://postgr.es/m/aDnaKTEf-0dLiEfz%40msg.df7cb.de
doc/src/sgml/ref/checkpoint.sgml
src/backend/postmaster/checkpointer.c
src/bin/psql/tab-complete.in.c
src/test/regress/expected/stats.out
src/test/regress/sql/stats.sql