Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Ludicrous Speed Postgres
Welcome!
Welcome! (6:15)
Prerequisites (If Needed)
psql Intro (5:54)
pg_stat_statements Intro (9:09)
Explain Intro (11:06)
Module 1: Performance Fundamentals
Intro & Mindset (1:46)
Optimization Framework (3:41)
Do Less Work (8:55)
Robbing Peter To Pay Paul (3:59)
Course Database (7:38)
Course Database Configuration (2:08)
Module 2: Exploring Btree Indexes
Intro & Finding Large Data (5:38)
Multi-Column Indexes (8:44)
Ordering With Btree Indexes (2:07)
Partial Indexes (5:35)
Expression Indexes (3:44)
Index-Only Scans & Covering Indexes (5:31)
Index Costs (1:28)
Module 3: Optimizing Indexes
Intro (0:48)
Vacuum (20:57)
Statistics & Analyze (7:17)
Extended Statistics (4:34)
Reindexing (7:11)
Remove Unused Indexes (2:48)
Module 4: Optimized Data & Index Types
Intro (0:53)
Data Type Decisions (7:58)
Array Data Types (5:49)
GIN Indexes (7:07)
Range Data Types (4:13)
GIST Indexes (3:32)
BRIN Indexes (5:43)
Hash Indexes (1:48)
Module 5: Text & JSON Search
Intro (0:48)
Btree Text Search (4:25)
Basic Full-Text Search (10:54)
Advanced Full-Text Search (16:30)
Fuzzy / Similar / Partial Text Search (11:23)
JSONB Search (12:50)
Module 6: Advanced Querying Techniques
Intro (1:20)
Distinct On (3:34)
Lateral Joins (4:24)
Union, Intersect, Except (4:14)
CTE & Materialized (3:34)
Paging & Keyset Pagination (4:42)
User Prefix Search Feature (7:09)
Module 7: Handling Excessive Data Changes
Intro (0:54)
General Guidance (5:46)
Too Many Inserts (11:44)
Too Many Updates (13:37)
Too Many Deletes (6:15)
Bulk Loading (6:53)
Module 8: Partitioning, Aggregates and Beyond
Intro (0:46)
Partitioning (16:57)
Materialized Views (8:51)
Summary Tables & Real-Time Aggregates (10:57)
Q & A Sessions
Q & A #1 2/29/2024 (46:21)
Q & A #2 3/11/2024 (52:17)
Q & A #3 3/18/2024 (64:02)
Q & A #4 3/25/2024 (31:00)
Q & A #5 4/1/2024 (42:07)
Q & A #6 4/8/2024 (20:39)
Q & A #7 4/15/2024 (53:33)
Q & A #8 4/22/2024 (18:04)
Q & A 6/10/2024 (29:55)
Bonuses
Unlocking AI with pgvector (14:01)
User Prefix Search Feature
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock