5 posts
Autovacuum is either ignored or cargo-cult tuned. I'll show how to turn it into an SLO-driven system with specific numbers, pg_stat metrics, and reproducible tests.
A practical playbook for safe database migrations in production. From expand/contract pattern through online indexes to monitoring and rollback.
A practical analysis of why soft delete destroys database performance over time. Benchmarks, partitioning solution, and migration checklist.
Queries on read replicas fail with 'canceling statement due to conflict with recovery'. The fix depends on which of the 5 conflict types you have - here's how to diagnose and solve each one.
Getting 'could not serialize access due to concurrent update'? The fix isn't just retry logic - it's understanding when to use which isolation level and how to reduce conflict frequency.