PostgreSQL autovacuum, explained for engeneers — slides from PostgreSQL Meetup at Zalando Berlin HQ
At the first Russian PGDay there was a sort of joke, right after PostgreSQL DBA tutorial: «we need an autovacuum tutorial». The topic is utmost important, poor configured vacuuming can easily screw your database up, but documentation covers only how to configure something (and that is the purpose of documentation), not a word about strategy and common approaches of autovacuum configuration for different workloads.
My talk at Berlin PostgreSQL meetup is some sort of alfa version: I improve it based on the feedback and will include more details and corner cases to present it on PGDay Russia 2015 at Sankt-Petersburg this July.
Stay tuned and thanks for German colleagues for a nice discussion!
