Re: wait event docs

Michael Paquier <[email protected]> Fri, 13 Dec 2019 15:50:29 +0900
Newsgroups gmane.comp.db.postgresql.devel.documentation
Message-ID <[email protected]>
--CEUtFxTsmBsHRLs3
Content-Type: text/plain; charset=iso-8859-1
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

On Thu, Dec 12, 2019 at 02:07:14PM -0800, Jeremy Schneider wrote:
> The wait event information in PostgreSQL is very helpful for
> troubleshooting.=A0 I always reference the PostgreSQL docs first, and when
> people ask me about wait events that where I send them first.=A0 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?=A0 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

--CEUtFxTsmBsHRLs3
Content-Type: application/pgp-signature; name="signature.asc"

-----BEGIN PGP SIGNATURE-----

iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAl3zNLUACgkQnvQgOdby
QH1bMQ//WHvNbQJZcVp1hKrPpMJxxuktA6kZeZ9TGIHJC0nv9QGngR9MY7s6zXAD
Omon8775ASCRrkPhALavkuXpaRT8+qg06q0fRFMdugY/YSv6oOZ5LwsIybAjAi+K
Nrb4sbi0/p1fxMJxVik8sLpRBcyc7QjEKTDon/ArtQy/u5F5sy0r+Ve3picJBySg
3X4JDGfnWl4bipBa8nzqTfpYZEPJmgU7jicShhYVcRPULfWv62T57K9XVtOzGfHB
sEI3thWzpBAg0DSGKEDNywvnOWMWkoKcGMpwOevnAEK5TPEkuj7oWbNeK2MSD/IK
HPKv79mBPr8vFHBrhk/GyaqA/17sfIGO6bkkpVManfF5wxMQyD3X153kB2Yoky+7
g+f0UhbQCH8oPNbI9DmsEHiE7TT0ZAiUKNCl21FAh2Oq3w8iCaJncxmoss/X1k9H
et9aTg9BV9J25JjNXhcxJrgGB2vqtMKOMIIYiIPVq+f3oF6G9lh1mfPsGXLNKV/N
42noKbsk+75OycZcI6zyFWIRQYk5dYVgHqDzM44ED1LmEFhyEE46FMOSPsBRSUyy
BbyfU4lmPhSm4Z5dgXhRSslXsU00a6g142jZqCGlY2uC5gBK8k/U04StGWAPd1SW
6bTGDfqO6lUdV/rfPDMyof4g/cMUBqKezyPPA/3fQOdBb+HXAak=
=qXSM
-----END PGP SIGNATURE-----

--CEUtFxTsmBsHRLs3--