Horton

Add wait events for checkpoint delay mechanism.

Thomas Munro <tmunro@postgresql.org>

View on postgr.es
Commit: 0013ba290b6684d095d93517ff2ca1fadf79bdb9
Author: Thomas Munro <tmunro@postgresql.org>
Date: 2023-10-13T03:43:22Z
Releases: 17.0 
Add wait events for checkpoint delay mechanism.

When MyProc->delayChkptFlags is set to temporarily block phase
transitions in a concurrent checkpoint, the checkpointer enters a
sleep-poll loop to wait for the flag to be cleared.  We should show that
as a wait event in the pg_stat_activity view.

Reviewed-by: Robert Haas <robertmhaas@gmail.com>
Reviewed-by: Michael Paquier <michael@paquier.xyz>
Discussion: https://postgr.es/m/CA%2BhUKGL7Whi8iwKbzkbn_1fixH3Yy8aAPz7mfq6Hpj7FeJrKMg%40mail.gmail.com

Files

PathChange+/−
src/backend/access/transam/xlog.c modified +4 −0
src/backend/utils/activity/wait_event_names.txt modified +2 −0

Discussion