Engineering writeups and incident post-mortems for #database.
Articles: 6In-depth engineering analysis: Post-mortem: PostgreSQL connection leak in background worker pool during upstream timeouts. Practical diagnostics, logs and production configuration.
In-depth engineering analysis: Zero-downtime database schema migrations: the Expand and Contract pattern in practice. Practical diagnostics, logs and production configuration.
In-depth engineering analysis: SQLite in high concurrency: WAL mode, mmap and proper busy_timeout tuning. Practical diagnostics, logs and production configuration.
In-depth engineering analysis: PostgreSQL connection starvation: PgBouncer transaction mode pitfalls with prepared statements. Practical diagnostics, logs and production configuration.
In-depth engineering analysis: MySQL 5.7 to 8.0 upgrade: optimizer regression with utf8mb4_0900_ai_ci collation. Practical diagnostics, logs and production configuration.
In-depth engineering analysis: PostgreSQL autovacuum freeze storm: production downtime due to transaction ID wraparound. Practical diagnostics, logs and production configuration.
