Ludicrous Speed Postgres
Course description
This course is dedicated to optimizing PostgreSQL performance with a focus on proper schema design and efficient database use. It is designed for those who want to quickly and practically master techniques to accelerate Postgres performance—from local improvements to reducing the overall system load.
The course is suitable for senior developers who want to delve deeper into the capabilities of Postgres and achieve impressive query accelerations; junior developers eager to advance in understanding large data optimization; and database administrators who aim to reduce CPU and disk loads through the right choice of indexes, schemas, and queries.
You will learn to work with multi-terabyte databases where tables contain billions of rows, master the optimization framework and benchmarking techniques, and acquire a set of tools to multiply accelerate performance (up to 1000x) and reduce infrastructure costs. By the end of the course, you will confidently approach optimization tasks and become the one who brings tangible results and real victories to the team.
Watch Online
All Course Lessons (64)
| # | Lesson Title | Duration | Access |
|---|---|---|---|
| 1 | Welcome! Demo | 06:16 | |
| 2 | psql Intro | 05:55 | |
| 3 | pg_stat_statements Intro | 09:10 | |
| 4 | Explain Intro | 11:07 | |
| 5 | Intro & Mindset | 01:47 | |
| 6 | Optimization Framework | 03:42 | |
| 7 | Do Less Work | 08:56 | |
| 8 | Robbing Peter To Pay Paul | 04:00 | |
| 9 | Course Database | 07:39 | |
| 10 | Course Database Configuration | 02:09 | |
| 11 | Intro & Finding Large Data | 05:39 | |
| 12 | Multi-Column Indexes | 08:45 | |
| 13 | Ordering With Btree Indexes | 02:08 | |
| 14 | Partial Indexes | 05:36 | |
| 15 | Expression Indexes | 03:45 | |
| 16 | Index-Only Scans & Covering Indexes | 05:32 | |
| 17 | Index Costs | 01:29 | |
| 18 | Intro | 00:49 | |
| 19 | Vacuum | 20:58 | |
| 20 | Statistics & Analyze | 07:17 | |
| 21 | Extended Statistics | 04:35 | |
| 22 | Reindexing | 07:12 | |
| 23 | Remove Unused Indexes | 02:49 | |
| 24 | Intro | 00:54 | |
| 25 | Data Type Decisions | 07:59 | |
| 26 | Array Data Types | 05:50 | |
| 27 | GIN Indexes | 07:08 | |
| 28 | Range Data Types | 04:14 | |
| 29 | GIST Indexes | 03:33 | |
| 30 | BRIN Indexes | 05:44 | |
| 31 | Hash Indexes | 01:49 | |
| 32 | Intro | 00:49 | |
| 33 | Btree Text Search | 04:26 | |
| 34 | Basic Full-Text Search | 10:55 | |
| 35 | Advanced Full-Text Search | 16:31 | |
| 36 | Fuzzy / Similar / Partial Text Search | 11:24 | |
| 37 | JSONB Search | 12:51 | |
| 38 | Intro | 01:21 | |
| 39 | Distinct On | 03:35 | |
| 40 | Lateral Joins | 04:25 | |
| 41 | Union, Intersect, Except | 04:15 | |
| 42 | CTE & Materialized | 03:35 | |
| 43 | Paging & Keyset Pagination | 04:43 | |
| 44 | User Prefix Search Feature | 07:10 | |
| 45 | Intro | 00:55 | |
| 46 | General Guidance | 05:47 | |
| 47 | Too Many Inserts | 11:45 | |
| 48 | Too Many Updates | 13:38 | |
| 49 | Too Many Deletes | 06:16 | |
| 50 | Bulk Loading | 06:54 | |
| 51 | Intro | 00:47 | |
| 52 | Partitioning | 16:58 | |
| 53 | Materialized Views | 08:52 | |
| 54 | Summary Tables & Real-Time Aggregates | 10:58 | |
| 55 | Q & A #1 2/29/2024 | 46:22 | |
| 56 | Q & A #2 3/11/2024 | 52:18 | |
| 57 | Q & A #3 3/18/2024 | 01:04:02 | |
| 58 | Q & A #4 3/25/2024 | 31:01 | |
| 59 | Q & A #5 4/1/2024 | 42:08 | |
| 60 | Q & A #6 4/8/2024 | 20:40 | |
| 61 | Q & A #7 4/15/2024 | 53:34 | |
| 62 | Q & A #8 4/22/2024 | 18:05 | |
| 63 | Q & A 6/10/2024 | 29:56 | |
| 64 | Unlocking AI with pgvector | 46:22 |
Unlock unlimited learning
Get instant access to all 63 lessons in this course, plus thousands of other premium courses. One subscription, unlimited knowledge.
Learn more about subscriptionComments
0 commentsWant to join the conversation?
Sign in to commentSimilar courses
SQL - The Complete Guide (MySQL, PostgreSQL & more)
Full-Stack Fundamentals 2 - Backend
SQL for Data Engineers
Fundamentals of Backend Engineering
