"PostgreSQL 分区表与热数据管理实践"

PostgreSQL 分区表与热数据管理实践创建分区表CREATE TABLE events ( id BIGSERIAL PRIMARY KEY, ts TIMESTAMP NOT NULL, payload JSONB ) PARTITION BY RANGE (ts); CREATE TABLE events_2025_11 PARTITION OF events FOR VALUES FROM ('2025-11-01') TO ('2025-12-01'); 附加新分区CREATE TABLE events_2025_12 PARTITION OF events FOR VALUES FROM ('2025-12-01') TO ('2026-01-01'); 索引与查询CREATE INDEX ON events (ts); EXPLAIN SELECT * FROM events WHERE ts >= now() - interval '7 days'; 维护定期创建/附加新分区，归档旧分区结合分区裁剪与索引提升查询性能总结分区表可有效管理时间序列与冷热数据，提升查询效率与维护便利性。