Autoplay
Autocomplete
Previous Lecture
Complete and continue
Postgres: Fundamentals of Index Tuning 2027 (Early Access)
Making Sure You're Ready for Class: Free Prerequisites
Welcome to the Class (3:59)
Concepts to Grasp First
Getting Your Computer Ready
Download the Scripts and Resources
1: Which Columns to Index
Which Columns Should You Index at First? (22:55)
Why You Shouldn't Start With Multi-Column Indexes (23:46)
Lab: Picking Columns to Index (4:32)
Watch Brent Do the Lab (31:10)
2: How Functional Indexes Help Timestamps and Varchars
Why Timestamp Columns Often Need Functional Indexes (15:26)
Lab: Designing Functional Indexes for Timestamp Columns (16:10)
Watch Brent Do the Lab (14:24)
3: Indexing for Sorts & Order By
Sorting Many Rows From One Table (24:28)
Sorting a Few Rows From One Table (10:54)
Lab: Designing Indexes for Order By (1:03)
Watch Brent Do the Lab (14:24)
4: How Partial Indexes Reduce Size and Overhead
Where Partial Indexes Make Sense (9:00)
Lab: Design Partial Indexes Where They Make Sense (1:19)
Watch Brent Do the Lab (7:37)
Sorting a Few Rows From One Table
Lecture content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock