数据库与存储
postgres-migration-observability
更新于 2026-08-09
PostgreSQL · 可观测性规则
Observability rules for PostgreSQL: intent-level traces, symptom-based alerts and owned dashboards.
- 技术栈
- PostgreSQL
- 主题
- 可观测性
- 条目
- 9 条
- 版本
- v0.2.0
✓ 应当这么做
- ✓ Emit one trace per user intent and one span per external call
- ✓ Alert on symptoms that pages a human, not on causes that do
- ✓ Keep dashboards owned, dated and tied to a decision
✕ 常见反模式
- ✕ High-cardinality labels (user id, raw path) in metrics
- ✕ Dashboards with no owner that nobody opens
- ✕ Alerts that fire on expected batch jobs
◎ 交付前验证
- ◎ 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 篇数据库与存储
PostgreSQL 工程规则
Zero-downtime PostgreSQL rules: expand/contract phases and concurrent index builds
数据库与存储
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