Postgres databases go slow 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.
Videos Ready to Watch Now
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
When Autovacuum Isn't Enough: Doing Manual Vacuums
Available in
days
days
after you enroll