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.
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
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 |
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 |
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 |