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 for free:

And when you’re ready to keep going, sign up for the course. See you in class!