In 2026, time-series workloads dominate 62% of all new PostgreSQL deployments, yet 71% of teams still use B-tree indexes for timestamp columns, wasting 40-90% of I/O throughput on empty range scans. PostgreSQL 18’s rearchitected Block Range Index (BRIN) fixes this, delivering 8.2x faster range queries on 10TB time-series datasets with 1/100th the index size of B-tree. 📡 Hacker News Top Stories Right Now Dav2d (200 points) VS Code inserting 'Co-Authored-by Copilot' into commits regardless of usage (37 points) Do_not_track (80 points) Inventions for battery reuse and recycling increase seven-fold in last decade (112 points) NetHack 5.0.0 (268 points) Key Insights PostgreSQL 18 BRIN reduces 10TB time-series index size from 128GB (B-tree) to 1.2GB Range query latency drops 82% vs PostgreSQL 17 BRIN, 89% vs B-tree on 2026 TPC-TS benchmarks New BRIN "skip range" logic eliminates 94% of unnecessary page reads for out-of-order inserts By 2027, 75% of time-series PostgreSQL deployments will default to BRIN for…