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…