Migrations

After 1.5 years running Postgres, here are the 8 operational mistakes that cause outages. Each failure mode will warn you about a landmine before you hit one. Give it a read…

A story about WAL segments, missing events, and the one line of SQL that should have been there from the start.

This article discusses best practices for versioned schema changes, safe column modifications, and managing replica lag across database clusters. Includes practical patterns for transactions, data batching, and rollback strategies to maintain high availability in production.