Ashraful’s Blog

Back to articles

Tag archive

#brin

#postgres #internals #brin #index

PostgreSQL 18 Internals: How the New BRIN Index Improves 2026 Time-Series Query Performance

In 2026, time-series workloads dominate 62% of all new PostgreSQL deployments, yet 71% of teams still...

May 2, 202614 min read0 reactions0 comments

#postgres #brin #index #recipe

Our PostgreSQL 17 BRIN index recipe for a 2TB time‑series table: 100x smaller than B‑tree

When our 2TB time-series table’s B-tree index hit 18GB, query latency spiked to 2.1s and vacuum...

May 2, 202613 min read0 reactions0 comments