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
Autovacuum Problem 2: Blocking on a Single Table
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock