PostgreSQL Field Notes

Notes for the problems that show up after launch: bad plans, awkward migrations, index debt, vacuum pressure, replica lag, and the small decisions that make PostgreSQL easier to operate.

PostgreSQL Topic Hubs

PostgreSQL Guide (Pillar)

pgvector Monitoring Query Optimizer Sizing Slow Query Monitoring Query Monitoring

PostgreSQL Tools

HNSW Tuning Lab Plan Autopsy Index Rollout

Tool Comparisons

Compare PostgreSQL monitoring tools

Browse by topic

pgvector and RAG Indexes Slow Queries Locks and Transactions Backups and Durability Replication and WAL Connections and Pooling CPU, Memory, and I/O Vacuum and Bloat Cloud Providers

January 7, 20266 min read

The Postgres Migration Review Checklist I Use Before Approving Any Schema Change

Production migration review is mostly lock review. The SQL can be correct and still dangerous if it rewrites a table, validates too much, or blocks writes.

January 3, 20267 min read

JSONB Indexing in Postgres: Where It Helps and Where People Get Surprised

JSONB columns are great. JSONB indexing has a steeper learning curve than the docs admit. Here is what works in production.