Presented by:

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.

Date:
2018 October 9 10:30
Duration:
40 min
Room:
Baobab
Conference:
South Africa 2018
Language:
English
Track:
Operations and Administration
Difficulty:
Medium