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.
Pick a Django cache backend, use cache_page, template fragment caching and the low-level API safely, and invalidate with signals and versioned keys.
How PostgreSQL streaming replication works, synchronous vs asynchronous commits, routing reads in Django, handling replication lag, and replicas for failover.
Move slow work off the request path: queues vs brokers vs streams, Celery in Django, retries and idempotency, dead letters, separate queues, and when Kafka is worth it.
Change a live Postgres schema without locking students out: expand and contract, lock timeouts, concurrent indexes, NOT VALID constraints, batched backfills, safe Django migrations.