Loading…
Tuesday, June 25 • 2:25pm - 3:10pm
Vacuuming: Through Pictures

Sign up or log in to save this to your schedule and see who's attending!

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. This talk will include 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.

Speakers
avatar for Tom Kincaid

Tom Kincaid

General Manager, 2nd Quadrant
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... Read More →
avatar for Andrew Dunstan

Andrew Dunstan

Database Architect, 2ndQuadrant
Andrew Dunstan is a PostgreSQL developer at 2ndQuadrant, a Core Committer on the PostgreSQL project and PostgreSQL Specialist.


Tuesday June 25, 2019 2:25pm - 3:10pm
Back Bay A The Sheraton Boston Hotel, 39 Dalton St, Boston, MA, 02199