wait event docs

Jeremy Schneider <[email protected]> Thu, 12 Dec 2019 14:07:14 -0800
Newsgroups	gmane.comp.db.postgresql.devel.documentation,gmane.comp.db.postgresql.general
Message-ID	<[email protected]>
--------------9025765581116A7B751F81F7
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: 8bit

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


--------------9025765581116A7B751F81F7
Content-Type: text/html; charset="utf-8"
Content-Transfer-Encoding: 8bit

<html>
  <head>

    <meta http-equiv="content-type" content="text/html; charset=UTF-8">
  </head>
  <body>
    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.<br>
    <br>
    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.<br>
    <br>
<a class="moz-txt-link-freetext" href="https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraPostgreSQL.Reference.html#AuroraPostgreSQL.Reference.Waitevents">https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraPostgreSQL.Reference.html#AuroraPostgreSQL.Reference.Waitevents</a><br>
    <br>
    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).<br>
    <br>
    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 <a class="moz-txt-link-freetext" href="https://wiki.postgresql.org/wiki/Wait_Events">https://wiki.postgresql.org/wiki/Wait_Events</a> ?<br>
    <br>
    If it does turn out to be useful for a lot of people then maybe it
    could even get into the PG docs someday.  :)<br>
    <br>
    -Jeremy<br>
    <br>
    <br>
    P.S. my wiki username is "Jer" 
    <a class="moz-txt-link-freetext" href="https://wiki.postgresql.org/wiki/User:Jer">https://wiki.postgresql.org/wiki/User:Jer</a><br>
    <br>
    <br>
    <pre class="moz-signature" cols="72">-- 
Jeremy Schneider
Database Engineer
Amazon Web Services</pre>
  </body>
</html>

--------------9025765581116A7B751F81F7--