PostgreSQL BRIN 索引与区间扫描优化实战

示例表与数据（时间序列）：CREATE TABLE events ( ts timestamptz NOT NULL, uid bigint NOT NULL, payload jsonb NOT NULL ); 创建 BRIN 索引并设置分段大小：CREATE INDEX idx_events_ts_brin ON events USING BRIN (ts) WITH (pages_per_range = 64); VACUUM ANALYZE events; 范围查询与计划验证：EXPLAIN ANALYZE SELECT * FROM events WHERE ts >= now() - interval '1 day' AND ts < now(); 维护建议：REINDEX INDEX idx_events_ts_brin; VACUUM (VERBOSE, ANALYZE) events;