What is connection pooling, and how does it work?
Why opening database connections is expensive, how pools lend and reuse them, two-tier pooling on large systems, Django's pool options, and the settings that matter.
Why opening database connections is expensive, how pools lend and reuse them, two-tier pooling on large systems, Django's pool options, and the settings that matter.
Restore Postgres to the second before a mistake: base backups and WAL archiving, recovery settings, pgBackRest, WAL-G and managed services, retention, and restore testing.
Session, transaction and statement pooling, what breaks in transaction mode, key pgbouncer.ini settings, PgBouncer vs Pgpool-II and managed proxies, and production tips.
Size database pools, Gunicorn workers and pods from real numbers with Little's Law, see why bigger pools slow Postgres down, and follow a worked exam-day example.
What 'sorry, too many clients already' means, how to find the culprits in pg_stat_activity, quick relief during an incident, and why raising max_connections isn't the fix.
Precompute leaderboards and reports inside PostgreSQL: create and index materialized views, refresh them concurrently, schedule refreshes, and know the alternatives.
B-trees in plain English, reading EXPLAIN ANALYZE, composite, partial and covering indexes, what indexes cost, and adding them to a live Postgres table safely.
How PostgreSQL streaming replication works, synchronous vs asynchronous commits, routing reads in Django, handling replication lag, and replicas for failover.
Change a live Postgres schema without locking students out: expand and contract, lock timeouts, concurrent indexes, NOT VALID constraints, batched backfills, safe Django migrations.