Horton

Log long wait time on recovery conflict when it's resolved.

Fujii Masao <fujii@postgresql.org>

View on postgr.es
Commit: 39b03690b529935a3c33024ee68f08e2d347cf4f
Author: Fujii Masao <fujii@postgresql.org>
Date: 2021-01-13T13:59:17Z
Releases: 14.0 
Log long wait time on recovery conflict when it's resolved.

This is a follow-up of the work done in commit 0650ff2303. This commit
extends log_recovery_conflict_waits so that a log message is produced
also when recovery conflict has already been resolved after deadlock_timeout
passes, i.e., when the startup process finishes waiting for recovery
conflict after deadlock_timeout. This is useful in investigating how long
recovery conflicts prevented the recovery from applying WAL.

Author: Fujii Masao
Reviewed-by: Kyotaro Horiguchi, Bertrand Drouvot
Discussion: https://postgr.es/m/9a60178c-a853-1440-2cdc-c3af916cff59@amazon.com

Files

PathChange+/−
doc/src/sgml/config.sgml modified +1 −1
src/backend/storage/buffer/bufmgr.c modified +11 −1
src/backend/storage/ipc/standby.c modified +36 −11
src/backend/storage/lmgr/proc.c modified +11 −1
src/include/storage/standby.h modified +2 −1

Documentation touched

Discussion