Database reliability and migrations
Query plans and slow queries
Query plans and slow queries
Postgres locks
Postgres locks and contention
- Choosing a Postgres Lock Timeout and Retry Policy
- Isolation Levels: Picking One and Testing Your Code Tolerates It
- Reading Postgres Locks and Bloat During a Migration
- A Concurrency Cap Between Agent Writes and Human Edits
- Detecting Lock Contention Without Reading pg_locks Manually
- Lock Contention Between Agent Writes and Human Edits
- Reading a Postgres Wait Event: Slow Query or Starved Query?
- Reading Lock Waits in Postgres During a Migration
- All of Postgres locks
Migrations without downtime
Migrations without downtime
- Database Migrations Without Downtime
- A Dry-Run Harness for Agent Migrations in CI
- Database Migrations in the Deploy Pipeline: Order and Safety
- Writing a Rollback Plan for a Schema Change
- A Migration Log Table: Fields to Keep After the Run
- Backfilling a Column in Batches With a Stop Switch
- Index Changes Through a Migration Pipeline: Locks and Rollback
- Killing a Running Migration: What Postgres Actually Does
- All of Migrations without downtime
Database performance tuning
Database performance tuning
- Postgres for Application Developers: The Parts That Matter
- Finding and Fixing Connection Pool Exhaustion
- Exporting Large Result Sets Without Blocking Writes
- Reading Replication Lag as a Product Signal
- Replica Read, Cache Lookup, Model Call: Ordering Steps
- Routing Reads to a Replica Without Stale Agent Memory
- Tuning Autovacuum for a Table That Grew During a Migration
Schema change review
Safe schema change review
- Checklists That Catch What a Second Reviewer Misses
- When a Coding Agent Writes the Migration: Dry Runs and Gates
- When a Coding Agent Writes the Migration: Gates and Dry Runs
- A Review Log That Shows Which Checklist Lines Catch Bugs
- A Schema History That Answers 'Who Changed This and Why'
- A Second Reviewer for Agent-Written Release Notes
- A Second Reviewer for Agent-Written Schema Changes
- Audit Trails for Agent-Written Schema Changes
- All of Schema change review
Rollouts and rollbacks