On Wed, 2020-11-25 at 11:41 +0100, Bernd Helmle wrote: > Am Mittwoch, den 25.11.2020, 13:47 +0900 schrieb Michael Paquier: > > > I can see the use case for IMMEDIATE, but I fail to see the use cases > > for WAIT and FORCE. CHECKPOINT_FORCE is internally implied for the > > end-of-recovery and shutdown checkpoints. WAIT could be a dangerous > > thing if disabled, as clients could pile up requests to the > > checkpointer for no real purpose. > > Wouldn't it be more convenient to use "FAST" for immediate checkpoint, > defaulting to "FAST ON"? That would be along the parameter used in the > streaming protocol command BASE_BACKUP, where "FAST" disables lazy > checkpointing.
+1 That would also match pg_basebackup's "-c fast|spread". Yours, Laurenz Albe
