DateTitleTags
Zero-Downtime Database Migrations: Our Rollback StrategyA failed migration doesn't have to mean downtime. Here's how we structure migrations so every change is safely reversible.
postgresqlinfrastructure
1m
postgresqlinfrastructure
1m
Tuning PgBouncer for a Read-Heavy APIWe cut p99 query latency by 40% just by changing three PgBouncer settings. Here's the before and after.
postgresqlperformance
1m
postgresqlperformance
1m
One Index That Fixed a 5-Second QueryA dashboard query was timing out. EXPLAIN ANALYZE showed a sequential scan on a 2M-row table. One index brought it to 8ms.
sqlpostgresql
1m
sqlpostgresql
1m