|
Sets the maximum length of time, in minutes, that the database server takes to recover from system failure.
Integer, in minutes
2
| 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 |
You may need to restart the database server for changes to this option setting to take effect.
This option is used with the checkpoint_time option to decide when checkpoints should be done.
The database server uses a heuristic to estimate the recovery time based on the operations that have been performed since the last checkpoint, and includes both the estimated recovery time and the estimated checkpoint time for the database. So, the recovery time is not exact.