Deep dive into Postgres internals, performance, and high availability.
Window functions, CTEs, recursive queries, and aggregations.
WAL, MVCC, shared buffers, and background writer.
EXPLAIN ANALYZE, index types (B-Tree, GiST, GIN), and query planning.
Vacuuming, bloat management, backup (pgBackRest), and restores.
Streaming replication, Patroni, pgBouncer, and logical replication.
Partitioning, sharding (Citus), and handling massive datasets.