Who I Am and How This Tier Is Different
Lesson notes coming soon.
PostgreSQL Administration — Intermediate
PostgreSQL Administration — Intermediate
Module 0 — Transition: From Operator to Administrator
- Who I Am and How This Tier Is Different
- What Changes at the Intermediate Level
- Reading PostgreSQL Behavior, Not Guessing
Module 1 — PostgreSQL Architecture (Deeper, Practical)
- PostgreSQL Process Model
- Shared Memory Explained
- Disk I/O & Caching
Module 2 — Storage & Table Internals
- Heap Tables Explained
- TOAST Internals
- Visibility Map & Free Space Map
- Table Bloat (The Real Causes)
Module 3 — Query Planning & Statistics (Admin Perspective)
- How PostgreSQL Estimates Rows
- PostgreSQL Statistics
- When Statistics Lie
- Extended Statistics
Module 4 — Indexing Strategy (Beyond “Add an Index”)
- B-Tree Index Internals
- Index Types & Use Cases
- Partial Indexes
- Expression Indexes
- When Indexes Hurt Performance
Module 5 — Autovacuum Deep Dive
- How Autovacuum Decides to Run
- Autovacuum Workers & Cost Limits
- Tuning Autovacuum Per Table
- Freeze Age & Wraparound
Module 6 — Performance Tuning (Responsible & Measured)
- Memory Tuning Fundamentals
- Checkpoints & WAL Tuning
- Connection Management
- Finding the Real Bottleneck
Module 7 — Backup & Recovery (Production Grade)
- Backup Strategies That Scale
- WAL Archiving
- Point-in-Time Recovery (PITR)
- Testing Recovery
Module 8 — Replication & Read Scaling (Intro)
- Streaming Replication Basics
- Replication Slots
- Read Replicas in Practice
- Failover Concepts
Module 9 — Intermediate Failure Scenarios
- Autovacuum Can’t Keep Up
- Query Plans Suddenly Change
- Replicas Falling Behind
- Performance Degrades Over Time
Module 10 — Intermediate Capstone
- Diagnose a Slow System
- Fix a Planner Problem
- Configure PITR & Recover Data
- Readiness for Expert Tier