PostgreSQL Administration & Performance Tuning

Name: PostgreSQL Administration & Performance Tuning
Availability: InStock

Master PostgreSQL from the inside out — MVCC internals, advanced indexing, high-availability replication, and production performance tuning. Build the skills to own a PostgreSQL installation end-to-end: configure, secure, back up, replicate, and diagnose slow queries under real workloads.

4.80/5.0

8 hours

0 enrolled

Updated May 2026

Course Content ↓

This course is included in Pro — $19.99/moUpgrade →

By Marcus Reid

What You'll Learn

Explain MVCC, WAL, and autovacuum internals and how they affect data consistency and storage

Identify the right index type (B-Tree, GIN, GiST, BRIN) for a given query pattern

Build a streaming replication setup with automatic failover using Patroni

Apply EXPLAIN ANALYZE to diagnose slow queries and validate index usage

Configure pg_stat_statements and pg_stat_* views to monitor live database health

Evaluate connection pooling strategies and implement pgBouncer in transaction mode

Prerequisites

Comfort with SQL — SELECT, JOIN, GROUP BY, subqueries
Basic Linux CLI — file editing, systemctl, ssh
Familiarity with at least one relational database concept (tables, indexes, transactions)

About the Instructor

Marcus Reid

Expert instructor with hands-on industry experience in Databases.

Included in paid plans

LevelIntermediate

Duration8 hours

Lessons—

Students0

Rating4.80 / 5.0

This course includes

Hands-on practice labs
AI-powered explanations
Progress tracking
Certificate of completion
Lifetime access

30-day money-back guarantee