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
| # | Title | Duration |
|---|---|---|
| 1 | Welcome! | 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 |
Comments
0 commentsSimilar courses
Fullstack Typescript with TailwindCSS and tRPC Using Modern Features of PostgreSQL
DuckDB - The Ultimate Guide
Building a Database Engine
Database Design & Implementation
Want to join the conversation?
Sign in to comment