Database
Performance
Database performance work grounded in measurement, not guessing. Find the actual bottleneck, fix it, verify the fix.
Query Optimization
EXPLAIN ANALYZE, index selection, join rewriting, and N+1 elimination. Finding the queries that are hurting you and fixing them with proof.
Index Strategy
B-tree, GIN, GiST, partial, and composite indexes — chosen based on actual query patterns. Adding the right index, not every index.
Connection Pooling
PgBouncer or Supabase Pooler configuration to stop running out of connections under load. Session, transaction, and statement mode explained.
Read Replicas & Caching
Offloading reads to replicas, Redis caching layers, and materialized views for expensive aggregations that don't need to run on every request.
Performance Monitoring
pg_stat_statements, slow query logging, and dashboards that show you what's getting slower over time before users notice.