Articles Cards Topics About

Tag

indexes

2 cards

Cards

B-tree, GIN, BRIN, partial and covering indexes compared by the question each one answers, and a billion-row table where BRIN costs 300 KB against a B-tree's 5 GB

DatabasesDay 44Sep 15, 2026

Not Every Index Is a Tree

system-design databases indexes

Index lookup against sequential scan for the same query, the row-count threshold where the planner switches, three ways statistics mislead it, and ANALYZE before reaching for a new index

DatabasesDay 42Sep 12, 2026

Why It Ignored Your Index

system-design databases query-planner

Stay in the loop

New articles on technology, finance, culture, and life. No spam, unsubscribe anytime.

Narchol

A word that carries meaning, weight, and intent.

About Disclaimer RSS

© 2026 Narchol. All rights reserved.