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

Documentation → PostgreSQL devel (2026-09-11 15:39:05 - git commit 962e0a723a2)

Supported Versions: Current (18) / 17

Development Versions: 19 / devel

This documentation is for an unsupported version of PostgreSQL.
You may want to view the same page for the current version, or one of the other supported versions listed above instead.

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