PostgreSQL
Connection pooling, query planning, schema design, and keeping PostgreSQL healthy under load.
Engineering Notes 1
- PostgreSQL Connection Pooling at Scale
PgBouncer vs built-in pooling — benchmarks, configuration, and why we run both in production.
Debugging Stories 1
- Finding the Missing Index with EXPLAIN ANALYZE
A 4-second query that looked innocent in staging — sequential scan on 40M rows in production.