Indexes

9 pages in this section.

The mental model behind PostgreSQL indexes: how the planner decides to use one, what an index actually costs on every write, and how to pick the right access method for a query pattern.

Explainer Indexing Query Planner Access Methods

Indexes Basics

Learn PostgreSQL index basics with 9 examples, including B-tree, composite, and unique indexes, and understand index write amplification costs.

Sql Indexes Access Paths Basics Indexes

B-tree Indexes

Learn how B-tree indexes optimize SQL queries for equality and range scans, including multicolumn order rules and common pitfalls.

Sql Indexes Access Paths B Tree Indexes

Partial & Covering Indexes

Learn how to optimize PostgreSQL queries using partial and covering indexes. Understand WHERE clauses, INCLUDE columns, and practical patterns.

Sql Indexes Access Paths Partial And Covering Indexes

GIN & GiST

Learn to optimize PostgreSQL queries with GIN and GiST indexes for full-text search, JSONB, arrays, and geospatial data.

Sql Indexes Access Paths Gin And Gist

BRIN

Sql Indexes Access Paths Brin

Index-Only Scans

Sql Indexes Access Paths Index Only Scans

Indexes Best Practices

Learn best practices for PostgreSQL indexes, including design, validation, and operations, to optimize query performance and resource usage.

Sql Indexes Access Paths Best Practices List

Indexes Highlights Summary

A single-page roundup of every highlight bullet from the 8 pages in the Indexes section, grouped by source page so you can scan all 43 takeaways without opening each article individually.

Highlights Summary Indexes Access Paths

Indexes

Search Documentation

Indexes