#PostgreSQL
— 4 posts
Mar 25, 2026 · 14m
Zero-Downtime Database Migrations: The Expand/Contract Playbook
How to change a production schema without taking traffic down — expand/contract, backfills, dual-writes, online DDL, and the migrations that always bite you.
DatabasePostgreSQLDevOps
Jan 14, 2026 · 14m
PostgreSQL Internals: MVCC, VACUUM, and HOT Updates
How Postgres actually stores rows — tuples, xmin/xmax, HOT updates, table bloat, and why VACUUM is the most misunderstood command in your database.
PostgreSQLDatabasePerformance
Apr 27, 2025 · 15m
Database Diagrams: A Practical Guide to Schema Design and Documentation
A comprehensive guide to database diagrams — covering ERD notations (Chen, Crow's Foot, UML), drawing with Mermaid and PlantUML, real-world schema examples, and best practices for documenting database designs.
DatabaseArchitecturePostgreSQL
Feb 3, 2025 · 10m
PostgreSQL Performance Tuning: Lessons from Production
After optimizing PostgreSQL for three high-traffic production systems, I've compiled the tuning strategies that actually moved the needle — from indexing patterns to connection pooling and query optimization.
PostgreSQLDatabasePerformance