Re: Orphaned wait event
Bertrand Drouvot <bertranddrouvot.pg@gmail.com>
From: "Drouvot, Bertrand" <bertranddrouvot.pg@gmail.com>
To: Thomas Munro <thomas.munro@gmail.com>,
Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>
Cc: pgsql-hackers <pgsql-hackers@postgresql.org>
Date: 2023-03-24T06:23:20Z
Lists: pgsql-hackers
Hi, On 3/23/23 11:00 PM, Thomas Munro wrote: > I think if we want proper automation here we > should look into a way to define wait events in a central file similar > to what we do for src/backend/storage/lmgr/lwlocknames.txt. It could > give the enum name, the display name, and the documentation sentence > on one tab-separated line, and we could generate all the rest from > that, or something like that? I suspect that downstream/monitoring > tools might appreciate the existence of such a file too. Yeah, I think that makes sense. I'll look at this and start a new thread once I've a patch to share. FWIW, I'm also working on wait event "improvements" (mainly adding extra info per wait event) that 1) I'll share once ready 2) could also probably benefit from your proposal here. Regards, -- Bertrand Drouvot PostgreSQL Contributors Team RDS Open Source Databases Amazon Web Services: https://aws.amazon.com
Commits
-
Re-add tracking of wait event SLRUFlushSync
- aeb6f4b3b0d0 14.8 landed
- 1ed1b84bdcd2 15.3 landed
- 84cc1426745b 16.0 landed
-
Defer flushing of SLRU files.
- dee663f78439 14.0 cited