CF

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

Creston Jamison is a US database engineer and the host of the long-running Scaling Postgres YouTube channel and weekly newsletter — one of the more authoritative independent sources on PostgreSQL performance and operations.

His CourseFlix listing carries Ludicrous Speed Postgres — a focused treatment of PostgreSQL performance engineering: indexing strategy, query optimisation, the EXPLAIN plan reading craft, partitioning, and the operational tuning that separates fast Postgres from generic Postgres.

Material is paid and aimed at engineers responsible for PostgreSQL performance on production systems. For broader content, see CourseFlix's Databases and SQL category pages.

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

Related courses

  • MySQL for Developers thumbnailUpdated 3mo ago

    MySQL for Developers

    By: Aaron Francis
    Study effective schema design, indexing, and query optimization in MySQL. The course is suitable for application developers of varying skill levels.
    7h 41m
  • Database Design Book thumbnailUpdated 9mo ago

    Database Design Book

    By: Alexey Makhotkin
    Discover the art of database design with our comprehensive book, aimed at transforming your basic task ideas into fully structured database table systems.
  • Effective Database Design thumbnailUpdated 2y ago

    Effective Database Design

    By: Ben Brumm
    The course "Effective Database Design" will provide you with an action plan, examples, and instructions for creating a well-designed database.
    1h 3m5/5

Frequently asked questions

What prerequisites are necessary to enroll in this course?
The course is designed for a range of learners from junior to senior developers and database administrators. While there are no strict prerequisites, having a basic understanding of PostgreSQL and SQL will be beneficial. Familiarity with database concepts and experience in handling large datasets would also be advantageous.
What types of projects or exercises are included in the curriculum?
Throughout the course, you will work with multi-terabyte databases and tables containing billions of rows. The curriculum includes exercises focused on schema design, creating and managing indexes like GIN, GIST, and BRIN, and optimizing queries using tools like pg_stat_statements and Explain. Real-world problem-solving exercises will enable you to implement performance enhancements effectively.
How does the course compare in depth and scope to similar courses?
This course offers a deep dive into PostgreSQL performance optimization, covering advanced topics such as multi-column indexes, full-text search, partitioning, and materialized views. Unlike introductory courses, it focuses on achieving substantial performance gains and reducing infrastructure costs, making it suitable for professionals seeking to optimize large-scale databases.
What specific tools or platforms will I learn to use?
You will gain proficiency in using tools such as pg_stat_statements for query performance analysis and benchmarking techniques to measure optimization results. The course also covers the use of various index types and PostgreSQL features like Vacuum and Reindexing to maintain and enhance database performance.
What topics are not covered in this course?
The course does not cover basic SQL queries or the foundational aspects of database design. It assumes a working knowledge of PostgreSQL and focuses on optimization rather than introductory database concepts. It also doesn't delve into non-PostgreSQL databases or cloud-based database solutions.
What is the expected time commitment for this course?
The course consists of 64 lessons, with a focus on hands-on experience and real-world application. While the total runtime is not specified, learners should be prepared to dedicate time to both lesson content and practical exercises. The course's depth suggests a significant time investment for those seeking comprehensive performance optimization skills.
How will the skills gained in this course benefit my career or other courses?
The optimization skills acquired in this course can significantly enhance your ability to manage and improve large-scale databases, a valuable asset in roles involving data management or software development. These skills are transferable to other advanced database courses and can lead to career advancement opportunities in database administration and backend development.