background-shape

Writing

Notes on AI engineering, programming, and shipping software in the AI-native era.

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