Add GUC to log long wait times on recovery conflicts.
Fujii Masao <fujii@postgresql.org>
Add GUC to log long wait times on recovery conflicts. This commit adds GUC log_recovery_conflict_waits that controls whether a log message is produced when the startup process is waiting longer than deadlock_timeout for recovery conflicts. This is useful in determining if recovery conflicts prevent the recovery from applying WAL. Note that currently a log message is produced only when recovery conflict has not been resolved yet even after deadlock_timeout passes, i.e., only when the startup process is still waiting for recovery conflict even after deadlock_timeout. Author: Bertrand Drouvot, Masahiko Sawada Reviewed-by: Alvaro Herrera, Kyotaro Horiguchi, Fujii Masao Discussion: https://postgr.es/m/9a60178c-a853-1440-2cdc-c3af916cff59@amazon.com
Files
| Path | Change | +/− |
|---|---|---|
| doc/src/sgml/config.sgml | modified | +22 −0 |
| doc/src/sgml/high-availability.sgml | modified | +6 −0 |
| src/backend/storage/buffer/bufmgr.c | modified | +30 −0 |
| src/backend/storage/ipc/standby.c | modified | +173 −26 |
| src/backend/storage/lmgr/proc.c | modified | +46 −2 |
| src/backend/utils/misc/guc.c | modified | +9 −1 |
| src/backend/utils/misc/postgresql.conf.sample | modified | +2 −0 |
| src/include/storage/standby.h | modified | +4 −1 |
Documentation touched
Discussion
- Add Information during standby recovery conflicts 82 messages · 2020-06-18 → 2021-01-13