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

Global Science Sat, 29 Aug 2026 16:27:39 GMT Moderate confidence — 64/100

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.
At Oracle I co-owned the Zonemaps module in the query engine and contributed to its core.

Unverified

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.
At Oracle I co-owned the Zonemaps module in the query engine and contributed to its core.

Sources: Deepsql