Database Internals

Theory and deep knowledge for working effectively with PostgreSQL — from SQL foundations to query optimization and disaster recovery.

For operational guides (migrations, connection management, monitoring), see Database Standards.

---

Contents

• SQL Fundamentals — JOINs, CTEs, window functions, PostgreSQL-specific features
• Query Performance — EXPLAIN ANALYZE, query plans, optimization techniques
• Indexing Strategies — B-tree, GIN, partial, composite indexes
• Transactions — ACID properties, isolation levels, locking, deadlock handling
• Backup & Recovery — pg_dump, PITR, disaster recovery procedures