Wait Events in PostgreSQL
Presented by:
David Wein
David is a Sr Principal Technologist at AWS where he works on Amazon Aurora. He currently heads the development of Aurora Limitless Database and has been a leader in the Aurora team since the inception of Aurora PostgreSQL. David has over 25 years of experience developing database kernels, having led development efforts in SAP HANA, SAP Sybase IQ, and SAP Sybase ASE. He is currently based in Seattle, USA.
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 SAST
- Duration:
- 40 min
- Room:
- Baobab
- Conference:
- South Africa 2018
- Language:
- English
- Track:
- Operations and Administration
- Difficulty:
- Medium