Tag: sql

Postgres indexing in practice: B-tree, GIN, BRIN, and when each one wins

Most slow queries aren't missing an index — they're using the wrong kind. A working tour of Postgres index types, partial and…