BRIN is 1/4570th the size of a B-tree, until 5% of rows are updated

·Hacker News··

I co-owned the Zonemaps module at Oracle, and BRIN is the same design in Postgres. It stops pruning long before pg_stats.correlation admits anything is wrong — at correlation 0.921, a 28x collapse. Measured on 10M rows, harness inline.

Read full article →

Related Articles

Should I run plain Docker Compose in production in 2026?
pmig · Hacker News · 3mo ago
Computer Use is 45x more expensive than structured APIs
palashawas · Hacker News · 3mo ago
Bun is being ported from Zig to Rust
SergeAx · Hacker News · 3mo ago
Show HN: Tilde.run – Agent sandbox with a transactional, versioned filesystem
ozkatz · Hacker News · 3mo ago
RaTeX: KaTeX-compatible LaTeX rendering engine in pure Rust
atilimcetin · Hacker News · 3mo ago