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