Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Fundamentals of Vacuum
Explaining Why Table Performance Degrades
How Postgres Stores Data in 8KB Pages (12:05)
Unvacuumed Tables are Bigger and Slower (14:20)
How Indexes are Affected Too (12:13)
How Autovacuum Tries to Fix It in the Background
What Autovacuum Does - and Doesn't Do (10:50)
Autovacuum Problem 1: Many Active Tables (16:33)
Autovacuum Problem 2: Blocking on a Single Table (12:27)
Autovacuum Problem 3: Transaction ID Wraparounds (Early Access, Work In Progress)
When Autovacuum Isn't Enough: Doing Manual Vacuums
Running Vacuum Manually (Early Access, Work In Progress)
Teach online with
Unvacuumed Tables are Bigger and Slower
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock