Wait! What’s going on Inside my Database?

Jeremy Schneider

PostgreSQL 9.6 introduced wait events and PostgreSQL 10 progressed them, but what are they? What do they mean? How do I find them and how do I make them go away? Wait events are one of the most significant advancements in observability for PostgreSQL databases; their usefulness is unparalleled in troubleshooting performance. This talk will go into all that and more as we perform a flyover of the field of database performance engineering in general, and then dive deep to explore the world of PostgreSQL wait events specifically.