Climbing B-tree Indexes in Postgres

Understand and apply the go-to index in Postgres for sorting and matching

Your query was slow so you decided to speed it up by adding an index. What type of index was it? Probably a B-tree.

Postgres has a few index types but B-trees are by far the most common. They’re good for sorting and matching; and once you understand what…