Search Postgresql Archives

wait event docs

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux