When I first started working with Postgres back in 2017, one of the first big surprises for me was the vacuum process.
Our query performance kept degrading, the database kept getting larger, and we couldn’t find clear, simple explanations of the problem and how to fix it.
In this class, I’ll explain:
- How Postgres keeps multiple versions of rows around
- How the autovacuum process tries to fix it
- How to tell when autovacuum isn’t keeping up
- What settings to change in order to help
- When you’ll need to do manual vacuums instead
Watch Module 1 Now for Free.
This module builds on my free Fundamentals of Select class – make sure you watch that one first to understand how Postgres stores data in pages.