Understanding Autovacuum by Dan Robinson
Tuesday, November 15 at 2:20-3:15
Autovacuuming is one of the most common causes of stubbed toes for PostgreSQL newbies. This talk will be a deep dive into what vacuuming and autovacuuming do, why they are necessary, how to tune them, and how to evaluate whether or not your tuning is correct. I'll also discuss some lessons learned from doing this in a pathologically bloat-heavy context.
About the Speaker
Dan is CTO at Heap, where he uses PostgreSQL, Kafka, Flink, Redis, and CitusDB to build distributed analytics infrastructure. He works in Scala and Node.js day-to-day, though he's been known to get a little too much satisfaction out of solving problems with PL/pgSQL. Dan earned B.S. degrees in Computer Science and Mathematics from Stanford, where spent most of his time studying machine learning. He likes hiking and building physical things.