数据库与存储
postgres-migration
更新于 2026-09-18
PostgreSQL 工程规则
Zero-downtime PostgreSQL rules: expand/contract phases and concurrent index builds
- 技术栈
- PostgreSQL
- 主题
- 工程基线
- 条目
- 9 条
- 版本
- v0.2.0
✓ 应当这么做
- ✓ Apply schema changes in expand/migrate/contract phases so old and new code co-exist
- ✓ Create indexes concurrently on live tables and verify lock behaviour before deploying
- ✓ Make every migration idempotent and reversible
✕ 常见反模式
- ✕ Long table rewrites under a global lock during business hours
- ✕ Implicit N+1 patterns in ORM relations touched by the change
- ✕ Destructive column drops in the same release as the read code removal
◎ 交付前验证
- ◎ EXPLAIN on the hot queries shows no sequential scan regression
- ◎ Migration rehearsed on a production-size snapshot
- ◎ Rollback path executed at least once in staging
同分类条目
26 篇数据库与存储
MySQL 工程规则
MySQL rules: online DDL awareness, lock timeouts and reversible migrations
数据库与存储
Redis 工程规则
Redis rules: explicit TTLs, versioned keys and stampede-safe misses
数据库与存储
MongoDB 工程规则
MongoDB rules: explicit schema validators and index-backed query shapes
数据库与存储
ClickHouse 工程规则
ClickHouse rules: partition pruning, column ordering and batch inserts
数据库与存储
Elasticsearch 工程规则
Elasticsearch rules: alias-based reindexing and mapping compatibility
数据库与存储
SQLite 工程规则
SQLite rules: WAL mode, short transactions and explicit schema migrations