wait event docs

From: Jeremy Schneider <schnjere(at)amazon(dot)com>
To: "pgsql-www(at)postgresql(dot)org" <pgsql-www(at)postgresql(dot)org>
Cc: <pgsql-docs(at)lists(dot)postgresql(dot)org>, pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: wait event docs
Date: 2019-12-12 22:07:14
Message-ID: fead9c82-6b58-b40f-1846-9521b76310f5@amazon.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs pgsql-general pgsql-www

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#AuroraPostgreSQL.Reference.Waitevents

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

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Michael Paquier 2019-12-13 06:50:29 Re: wait event docs
Previous Message David G. Johnston 2019-12-11 22:55:01 Re: Example for unnest(anyarray, anyarray) fails

Browse pgsql-general by date

  From Date Subject
Next Message Josef Šimánek 2019-12-13 01:11:06 Re: REINDEX VERBOSE unknown option
Previous Message Thomas Munro 2019-12-12 22:00:00 Re: When are Predicate Locks Freed

Browse pgsql-www by date

  From Date Subject
Next Message Michael Paquier 2019-12-13 06:50:29 Re: wait event docs
Previous Message Liaqat Andrabi 2019-12-12 14:54:27 Re: Update 2UDA Description on Downloads page