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 is a debt-based system that pays for fast writes on credit. It's up to vacuum to pay the bills before it's too late.
Vacuum remains one of the most challenging and mysterious aspects of PostgreSQL. Most users know the why of vacuum but are fuzzy on the how. This session will be a deep dive into the internals of vacuum, its algorithms, and includes a discussion of how vacuum uses resources and how you can tune your system for more efficient vacuuming. As part of the session we will review PostgreSQL's transaction clock, MVCC mechanism, and page layout.
- Date:
- 2018 October 9 13:00 SAST
- Duration:
- 40 min
- Room:
- Yellowwood
- Conference:
- South Africa 2018
- Language:
- English
- Track:
- Operations and Administration
- Difficulty:
- Medium