Обсуждение: Re: wait event docs

Поиск
Список
Период
Сортировка

Re: wait event docs

От
Michael Paquier
Дата:
On Thu, Dec 12, 2019 at 02:07:14PM -0800, Jeremy Schneider wrote:
> 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.

(I think that it would be better to avoid cross-posting among multiple
lists.  Please note that I have removed -www and -general in my reply,
keeping -docs because that7s the most meaningful)

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

That sounds like a good idea, as it is true that the docs are rather
sparse about the meaning behind a given wait event showing a lot in
profiles and what it actually means for your application.  We have a
couple of links from the docs to the wiki, so it could be an idea to
add a link to the wiki in the docs near the wait event table.  more to
the point, this makes me wonder if actually a better place for such
stuff would be a new section dedicated to wait event profiles here:
https://www.postgresql.org/docs/devel/monitoring.html
--
Michael

Вложения

Re: wait event docs

От
Bruce Momjian
Дата:
On Fri, Dec 13, 2019 at 03:50:29PM +0900, Michael Paquier wrote:
> On Thu, Dec 12, 2019 at 02:07:14PM -0800, Jeremy Schneider wrote:
> > 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.
> 
> (I think that it would be better to avoid cross-posting among multiple
> lists.  Please note that I have removed -www and -general in my reply,
> keeping -docs because that7s the most meaningful)
> 
> > 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 ?
> 
> That sounds like a good idea, as it is true that the docs are rather
> sparse about the meaning behind a given wait event showing a lot in
> profiles and what it actually means for your application.  We have a
> couple of links from the docs to the wiki, so it could be an idea to
> add a link to the wiki in the docs near the wait event table.  more to
> the point, this makes me wonder if actually a better place for such
> stuff would be a new section dedicated to wait event profiles here:
> https://www.postgresql.org/docs/devel/monitoring.html

Agreed, it probably should be in the official docs.

-- 
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

+ As you are, so once was I.  As I am, so you will be. +
+                      Ancient Roman grave inscription +