Course Code:
postgresqlbspk
Duration:
35 hours
Prerequisites:
-
Overview:
-
Course Outline:
Architecture
Memory management, CPU, IO, cgroup for postgresql – resource management
Basic configuration & Installation
Access Control
Backup (logical, physical, PITR) - in depth
Replication (sync, async, replication slots) - in depth
Extensions: FDW, monitoring, statement optimization
partitioning
PLPGSQL - cover basics for Admins
Slony
Upgrade
Tablespaces
Vacuum including extensions
HOT
Query plans
Transactions and locking
Indexes
CTEs
Monitoring
Logs