Wait! What's going on inside my database? Understanding PostgreSQL wait events
Jeremy Schneider is a Database Engineer at Amazon Web Services. Bringing his background with large-scale data processing and enterprise relational databases to the table, he works largely with PostgreSQL engines at AWS: Amazon RDS PostgreSQL and Amazon Aurora with PostgreSQL compatibility. He deeply enjoys collaborating with AWS customers and back-end engineers to architect and operate applications that are fast and reliable while meeting business requirements such as integration, compliance and security.
No video of the event yet, sorry!
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 explore the world of PostgreSQL wait events.
Slides are online at https://www.slideshare.net/ardentperf/wait-whats-going-on-inside-my-database-173880246 - this talk has been given quite a few times over the past year at user groups and conferences; it has been well received and it always continues to improve!
- 50 min
- Postgres Conference 2020
- Ops and Administration