Vacuuming through pictures
Tom in the General Manager for 2ndQuadrant in North America. He has been developing, deploying and supporting Database Systems and Enterprise Software for over 25 years. Tom had total product delivery ownership for the Progress OpenEdge platform which included a relational database deployed in thousands of systems and Enterprises all over the world. Tom was VP of Professional Services and later Vice President of products and engineering at EnterpriseDB. Responsibilities in his past include the management and maintenance of over 300 Postgres 24x7 database clusters. He has overseen the design and delivery of Postgres training solutions as well as the deployment of PostgreSQL at both Fortune 500 financial institutions and at military facilities all over the world. Teams he has managed have delivered major features that have become part of PostgreSQL. He overseen the design and and successful delivery of High Availability products for PostgreSQL and several other databases.
Andrew has been contributing to PostgreSQL since 2002 and has been a committer since 2005. He has contributed in a many areas, including configuration and logging enhancements, dollar quoting, CSV import and export, improvements to plperl, the Windows port, rewriting the initdb and pg_ctl scripts in C, parallel pg_restore and more recently JSON features and fast column addition. He created and maintains the PostgreSQL Buildfarm.
No video of the event yet, sorry!
Proper Vacuum operations is an important function of any Postgres deployment. Vacuum is at the core of many Postgres operational items. Having a Postgres deployment properly tuned for vacuum is critical for all successful Postgres production instances.
Unfortunately, may people struggle with the concepts behind vacuum and auto-vacuum. Hence, DBAs and Developers become extremely confused about how to tune the critical functionality associated with them (i.e. reclaiming dead tuples, freezing tuples and analyzing tables).
This talk will cover some key concepts of Postgres Vacuum and Autovacuum and some of the concepts around properly tuning Vacuum. While talks similar to this talk has been given many times before, this talk will be differentiated by the extensive use of diagrams, illustrations and animations to present the concepts around Postgres Vacuum and tuning Postgres Vacuum. The talk will be augmented with real life stories about how tuning vacuum properly makes a difference.
The primary audience of this talk are people who have often heard of Vacuum but have never quite understood why it is necessary and for people who do understand Postgres Vacuum but have struggled to explain it.
- 2019 September 20 10:00
- 50 min
- Silicon Valley 2019
- Ops and Administration