Home/Courses/PostgreSQL/PostgreSQL Performance Engineering

PostgreSQL Performance Engineering⚡

Advanced

PostgreSQL 18

Master query optimization, indexing strategies, and performance tuning for production PostgreSQL databases. Learn to analyze execution plans, design efficient indexes, and maintain high-performance systems.

6

Sections

18

Lessons

18

Challenges

Start this free course

Start learning PostgreSQL Performance Engineering

18 lessons and 18 challenges, all 100% free.

Start this course

The Query Planner

EXPLAIN Fundamentals

Understanding Cost(Sign in required)

Intermediate+20 Mana

Scan Types Deep Dive

Index Only Scan Requirements(Sign in required)

Intermediate+20 Mana

Bitmap Scan Purpose(Sign in required)

Advanced+30 Mana

Specialized Index Types

GIN Index Use Case(Sign in required)

Intermediate+20 Mana

Partial and Expression Indexes

Partial Index Usage(Sign in required)

Intermediate+20 Mana

BRIN Index Suitability(Sign in required)

Advanced+30 Mana

Introduction to Partitioning

Managing Partitions

Choosing Partition Type(Sign in required)

Intermediate+20 Mana

Sub-partitioning and Partition Strategies

Partition Pruning(Sign in required)

Intermediate+20 Mana

Detach vs Drop Partition(Sign in required)

Advanced+30 Mana

Understanding MVCC

VACUUM Operations

Dead Tuples(Sign in required)

Intermediate+20 Mana

Advanced VACUUM Strategies

VACUUM FULL Usage(Sign in required)

Intermediate+20 Mana

Autovacuum Trigger Formula(Sign in required)

Advanced+30 Mana

PostgreSQL Statistics Views

Query Analysis with pg_stat_statements

Cache Hit Ratio(Sign in required)

Intermediate+20 Mana

Lock Monitoring and Wait Events

Finding Unused Indexes(Sign in required)

Intermediate+20 Mana

Total Time vs Mean Time(Sign in required)

Advanced+30 Mana

Column Statistics

Planner Configuration

SSD Configuration(Sign in required)

Intermediate+20 Mana

Query Optimization Patterns

Extended Statistics(Sign in required)

Advanced+30 Mana

work_mem Consideration(Sign in required)

Advanced+30 Mana

Ready to start this free course?

No credit card required.

Start this course now

Ready to start PostgreSQL Performance Engineering?

18 interactive lessons and 18 hands-on challenges — learn in VS Code, Cursor, or the web.