Wait Events in PostgreSQL
David Wein is a Principal Software Engineer at Amazon Web Services where he works on RDS - Amazon’s Relational Database Service. David’s primary focus at AWS has been the development of Amazon Aurora PostgreSQL-compatible Edition. Prior to AWS, David was a Development Architect at SAP where he implemented persistence and recovery in the HANA in-memory database engine. David came to SAP from Sybase where he was a lead engineer on the Adaptive Server Enterprise database kernel and the in-memory store of Sybase IQ. He earned an M.S. in Interdisciplinary Telecommunications from the College of Engineering and Applied Science at the University of Colorado at Boulder.
PostgreSQL 9.6 introduced wait events, and support was greatly enhanced in version 10. Simply put, wait events tell you why a query isn't making progress. This talk will cover how to monitor waits as well as the most common waits encountered and what they mean. Finally, we will introduce enhanced wait event monitoring available in Amazon's Aurora PostgreSQL.
- 2018 October 9 10:30
- 40 min
- South Africa 2018
- Operations and Administration