PostgreSQL: Documentation: 18: Chapter 65. Built-in Index Access Methods

PostgreSQL: Documentation: 18: Chapter 65. Built-in Index Access Methods

August 13, 2026: PostgreSQL 18.6, 17.11, 16.15, 15.19, 14.24 and 19 Beta 3 Released!

Documentation → PostgreSQL 18

Supported Versions: Current (18) / 17

Development Versions: 19 / devel

Chapter 65. Built-in Index Access Methods
Prev	Up	Part VII. Internals	Home	Next

Chapter 65. Built-in Index Access Methods

Table of Contents

65.1. B-Tree Indexes

65.1.1. Introduction
65.1.2. Behavior of B-Tree Operator Classes
65.1.3. B-Tree Support Functions
65.1.4. Implementation

65.2. GiST Indexes

65.2.1. Introduction
65.2.2. Built-in Operator Classes
65.2.3. Extensibility
65.2.4. Implementation
65.2.5. Examples

65.3. SP-GiST Indexes

65.3.1. Introduction
65.3.2. Built-in Operator Classes
65.3.3. Extensibility
65.3.4. Implementation
65.3.5. Examples

65.4. GIN Indexes

65.4.1. Introduction
65.4.2. Built-in Operator Classes
65.4.3. Extensibility
65.4.4. Implementation
65.4.5. GIN Tips and Tricks
65.4.6. Limitations
65.4.7. Examples

65.5. BRIN Indexes

65.5.1. Introduction
65.5.2. Built-in Operator Classes
65.5.3. Extensibility

65.6. Hash Indexes

65.6.1. Overview
65.6.2. Implementation

Prev	Up	Next
64.2. Custom WAL Resource Managers	Home	65.1. B-Tree Indexes

Submit correction

If you see anything in the documentation that is not correct, does not match your experience with the particular feature or requires further clarification, please use this form to report a documentation issue.