B-tree
Default. Equality + range. Sorted access. Foundation.
Advertisement
GIN
Inverted index. jsonb key search. tsvector full-text. Array contains. Slower writes, faster reads.
Advertisement
GIST
Generalized search tree. PostGIS geometry. Range types. Nearest-neighbor searches.