public inbox for [email protected]  

help / color / mirror / Atom feed

From: Jeremy Schneider <[email protected]>
To: [email protected] <[email protected]>
Cc: [email protected]
Cc: pgsql-general <[email protected]>
Subject: wait event docs
Date: Thu, 12 Dec 2019 14:07:14 -0800
Message-ID: <[email protected]> (raw)

The wait event information in PostgreSQL is very helpful for
troubleshooting.  I always reference the PostgreSQL docs first, and when
people ask me about wait events that where I send them first.  The list
of wait events there is comprehensive, but the descriptions are a bit
terse and often use vocabulary that requires some familiarity with the
internals to understand.

AWS created some wait event documentation for Aurora with PostgreSQL
compatibility which takes a slightly different approach.  It's a lot
more words... but it tries to give useful suggestions about how to
improve (or fix) the system when a particular wait event is encountered.

https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraPostgreSQL.Reference.html#AuroraP...

Something like this would be really valuable for open source PostgreSQL
too.  While somebody's personal blog is one solution, it doesn't seem
wholly inappropriate to live on a community resource.  I'd be happy to
seed the content and continue making updates it as I regularly helping
people solve problems on open source community PostgreSQL (and hopefully
others contribute too).

Could we create a new wiki page as a starting point, and we could draft
up and maintain something there for a little while?  Maybe a place like
https://wiki.postgresql.org/wiki/Wait_Events ?

If it does turn out to be useful for a lot of people then maybe it could
even get into the PG docs someday.  :)

-Jeremy


P.S. my wiki username is "Jer"  https://wiki.postgresql.org/wiki/User:Jer


-- 
Jeremy Schneider
Database Engineer
Amazon Web Services

view thread (3+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected], [email protected]
  Subject: Re: wait event docs
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox