Postgres: Fundamentals of Vacuum 2027 (Early Access)
Understanding this database maintenance task is a crucial part of keeping your PostgreSQL databases lean and mean.
What you will get:
- Watch on any Device
- 3 sections
- lectures
- of video
Last updated: 20 Aug 2026
Your Instructor
I make Microsoft SQL Server go faster. I've been working with SQL Server since the late 1990s, and I'm one of the rare Microsoft Certified Masters of SQL Server. I love teaching, travel, and laughing. I live in Las Vegas, Nevada.
Postgres gets slower over time.
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 & why Postgres keeps old versions of rows around, how autovacuum tries to fix it, how you can tell when it's not keeping up, and how to fix it for faster queries.
Course Curriculum
Making Sure You're Ready for Class: Free Prerequisites
Available in
days
days
after you enroll
Explaining Why Table Performance Degrades
Available in
days
days
after you enroll
How Autovacuum Tries to Fix It in the Background
Available in
days
days
after you enroll
