POSTGRES INDEX TYPES EXPLAINED: B-TREE, GIN, BRIN, AND OPERATORS

Summary from the TLDR Data newsletter

A practical refresher on matching Postgres index types to equality, range, array, JSONB, text-search, and append-only time-series access patterns.