Skip to main content

Ludicrous Speed Postgres

12h 27m 44s
English
Paid

Unlock the potential of your PostgreSQL setup with our comprehensive course designed for performance optimization. Focused on proper schema design and efficient database use, this course equips you with the skills needed to significantly accelerate Postgres performance—from targeted improvements to reducing overall system load.

Who Should Enroll?

This course caters to a diverse range of learners:

  • Senior Developers: Deepen your understanding of Postgres capabilities and achieve remarkable query accelerations.
  • Junior Developers: Gain advanced insights into large data optimization.
  • Database Administrators: Learn techniques to minimize CPU and disk loads through optimal index, schema, and query selections.

What You Will Learn

Throughout the course, you will:

  • Work with multi-terabyte databases containing tables with billions of rows.
  • Master the optimization framework and benchmarking techniques.
  • Acquire a comprehensive set of tools to exponentially enhance performance (up to 1000x) and cut down infrastructure costs.

By the completion of this course, you will approach optimization tasks with confidence and become the key player in delivering tangible results and real victories to your team.

Why Choose This Course?

With a focus on practical outcomes, you will not only learn theory but also gain hands-on experience that empowers you to implement what you've learned effectively in real-world scenarios.

About the Author: Creston Jamison

Creston Jamison thumbnail

Hello! My name is Creston Jamison. Since the late 1990s, I have worked with Microsoft SQL Server, transitioned to Oracle in the early 2000s, and since 2008, I have been working with PostgreSQL for over 15 years. About eight years ago, I started consulting companies on PostgreSQL, and in 2018, I launched a weekly show called Scaling Postgres, where I recently celebrated the release of the 300th episode. I help clients optimize the performance of their databases, achieving performance boosts up to 10,000 times, and successfully manage multi-petabyte systems with trillions of rows.

Watch Online 64 lessons

This is a demo lesson (10:00 remaining)

You can watch up to 10 minutes for free. Subscribe to unlock all 64 lessons in this course and access 10,000+ hours of premium content across all courses.

View Pricing
0:00
/
#1: Welcome!
All Course Lessons (64)
#Lesson TitleDurationAccess
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 subscription