Sets the maximum number of minutes that the database server runs without doing a checkpoint.
Integer
60
PUBLIC role | For current user | For other users | |
---|---|---|---|
Allowed to set permanently? | Yes, with SET ANY SYSTEM OPTION | No | No |
Allowed to set temporarily? | Yes, with SET ANY SYSTEM OPTION | No | No |
This option is used with the recovery_time option to decide when checkpoints should be done.
You may need to shut down and restart the database server for the change to take effect.