Writing
Notes on AI engineering, programming, and shipping software in the AI-native era.
February 18, 2022 · 7 min read
Postgres Multi-Column Indexes, Column Order Is Almost Everything
February 16, 2022 · 6 min read
Postgres Partial Indexes That Make Slow Queries Disappear
February 14, 2022 · 6 min read
Postgres Index Types, B-tree, GIN, GiST, BRIN, When Each One Wins
February 11, 2022 · 6 min read
PgBouncer Connection Pooling for Postgres, A Practical Setup
February 9, 2022 · 6 min read
Postgres Autovacuum, When Defaults Fail and How to Fix Them
February 7, 2022 · 6 min read
Tuning Postgres Memory, shared_buffers, work_mem, effective_cache_size
February 4, 2022 · 6 min read
Reading the Postgres Query Planner, A Practical EXPLAIN Walkthrough
February 2, 2022 · 6 min read
Postgres Performance Tuning, My 2022 Checklist
January 31, 2022 · 6 min read
What I Learned Containerizing 11 Services in One Month
January 28, 2022 · 6 min read
Sharing a Postgres Database Between a Monolith and New Services
January 26, 2022 · 5 min read
Containerizing a Go Service, A Sub-15MB Production Image
January 24, 2022 · 6 min read