PostgreSQL Training
Upgrade patterns
PostgreSQL Training
0%
Completed
M1 — PostgreSQL Architecture and SQL Refresher
Process and memory model
Reading
WAL and checkpoints
Reading
psql basics
Reading
DDL and data types
Reading
M2 — SQL Power Skills
Window functions
Reading
CTEs and recursive CTEs
Reading
JSONB and arrays
Reading
Full-text search
Reading
M3 — Indexes and Statistics
B-tree, GIN, GiST, BRIN
Reading
Partial and expression indexes
Reading
VACUUM, ANALYZE, planner stats
Reading
Index-only scans
Reading
M4 — Transactions, MVCC and Locking
MVCC internals
Reading
Isolation levels and anomalies
Reading
Locks: row, page, advisory
Reading
Deadlocks and detection
Reading
M5 — Performance Tuning
EXPLAIN ANALYZE deep dive
Reading
pg_stat_statements
Reading
Connection pooling with PgBouncer
Reading
Memory and work_mem tuning
Reading
M6 — Partitioning and Sharding Patterns
Declarative partitioning
Reading
Partition pruning
Reading
Foreign tables and sharding
Reading
TimescaleDB extensions
Reading
M7 — Replication and High Availability
Streaming replication
Reading
Logical replication
Reading
Patroni and etcd
Reading
Failover and quorum
Reading
M8 — Backup, Restore and PITR
pgBackRest fundamentals
Reading
PITR configuration
Reading
Disaster recovery drills
Reading
Encryption and WORM
Reading
M9 — Operations and Observability
Monitoring with pgwatch / Prometheus
Reading
Alerting on replication lag
Reading
Maintenance windows
Reading
Upgrade patterns
Reading
M10 — Capstone and Certification Prep
Production HA cluster build
Reading
Performance case studies
Reading
PostgreSQL Certified Engineer mocks
Reading
More
Announcements
Course Info