Skip to content

Glossary: PostgreSQL Beyond the Basics

B-tree

Also written: btree

The default index type, which keeps values sorted. It handles `=`, ranges and sorting, and it can be read forwards or backwards.

Where the book teaches it

Related terms

Multicolumn indexPartial indexBRIN