| From: | Thomas Munro <tmunro(at)postgresql(dot)org> |
|---|---|
| To: | pgsql-committers(at)lists(dot)postgresql(dot)org |
| Subject: | pgsql: Add wait events for checkpoint delay mechanism. |
| Date: | 2023-10-13 03:50:49 |
| Message-ID: | E1qr9CK-000HZM-JW@gemulon.postgresql.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-committers |
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(at)gmail(dot)com>
Reviewed-by: Michael Paquier <michael(at)paquier(dot)xyz>
Discussion: https://postgr.es/m/CA%2BhUKGL7Whi8iwKbzkbn_1fixH3Yy8aAPz7mfq6Hpj7FeJrKMg%40mail.gmail.com
Branch
------
master
Details
-------
https://git.postgresql.org/pg/commitdiff/0013ba290b6684d095d93517ff2ca1fadf79bdb9
Modified Files
--------------
src/backend/access/transam/xlog.c | 4 ++++
src/backend/utils/activity/wait_event_names.txt | 2 ++
2 files changed, 6 insertions(+)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Paquier | 2023-10-13 04:01:55 | pgsql: Add support for AT LOCAL |
| Previous Message | Michael Paquier | 2023-10-13 02:00:18 | pgsql: doc: Mention timezone(zone, time) in section for AT TIME ZONE |