B-tree

Indexing

The default index type in PostgreSQL. A balanced tree structure supporting equality and range queries. Maintains sorted order. Optimal for high-cardinality columns.

Related terms

IndexGINGiST