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; ```