Databases · intermediate
PostgreSQL Administration & Performance Tuning
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.
- 8 hours
- 17 lessons
- 4 modules
- updated May 2026
Try it before you sign up
Read a full lesson and answer 3 questions from the Module 1 quiz. No account needed.
How PostgreSQL Works: MVCC, WAL, and Autovacuum
4 modules, 17 lessons
Module 1 is free — lessons, hands-on walkthrough and quiz.
- readHow PostgreSQL Works: MVCC, WAL, and Autovacuum25 min
- videoPostgreSQL MVCC and VACUUM Internals25 min
- hands-onHands-On: Configure PostgreSQL Roles, pg_hba.conf, and Autovacuum20 min
- quizModule 1 Quiz: Architecture & Setup10 min
Built by the CloudaQube team
No celebrity instructor — here is exactly what goes into the course instead.
- 01 5 guided hands-on walkthroughs you run in a real environment.
- 02 4 module quizzes — every answer comes with an explanation.
- 03 Last updated May 2026.
- 04 Any module can become a hands-on lab in Labs Studio.
What you'll be able to do
- 01 Explain MVCC, WAL, and autovacuum internals and how they affect data consistency and storage
- 02 Identify the right index type (B-Tree, GIN, GiST, BRIN) for a given query pattern
- 03 Build a streaming replication setup with automatic failover using Patroni
- 04 Apply EXPLAIN ANALYZE to diagnose slow queries and validate index usage
- 05 Configure pg_stat_statements and pg_stat_* views to monitor live database health
- 06 Evaluate connection pooling strategies and implement pgBouncer in transaction mode
- — 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)
Before you start
How long does it take?
About 8 hours of lessons, videos and hands-on walkthroughs across 4 modules.
What’s free?
Module 1 in full — lessons, hands-on walkthrough and quiz — with no card required. Any paid plan (from $8.99/mo) unlocks all 4 modules, and starts with a 14-day free trial.
Start the course with Module 1 free.
No card required. Unlock every module from $8.99/mo when you’re ready.