April East Bay Meeting: PostgreSQL Adores a Vacuum, by Quinn Weaver
Details
This talk is a deep dive into vacuuming. I'll explain how autovacuum works (and why), how to know when it's not working, how to tune it for optimal performance, and how to undo technical debt caused by falling behind.
Want a preview? Slides for the talk are available at http://fairpath.com/vacuum-slides.pdf
