PostgreSQL: Documentation: 17: Chapter 64. Built-in Index Access Methods

Content-Length: 20519 | pFad | http://www.postgresql.org/docs/17/indextypes.html

PostgreSQL: Documentation: 17: Chapter 64. Built-in Index Access Methods

May 8, 2025: PostgreSQL 17.5, 16.9, 15.13, 14.18, and 13.21 Released! | PostgreSQL 18 Beta 1 Released!

Documentation → PostgreSQL 17

Supported Versions: Current (17)

Development Versions: 18 / devel

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

Chapter 64. Built-in Index Access Methods

Table of Contents

64.1. B-Tree Indexes

64.1.1. Introduction
64.1.2. Behavior of B-Tree Operator Classes
64.1.3. B-Tree Support Functions
64.1.4. Implementation

64.2. GiST Indexes

64.2.1. Introduction
64.2.2. Built-in Operator Classes
64.2.3. Extensibility
64.2.4. Implementation
64.2.5. Examples

64.3. SP-GiST Indexes

64.3.1. Introduction
64.3.2. Built-in Operator Classes
64.3.3. Extensibility
64.3.4. Implementation
64.3.5. Examples

64.4. GIN Indexes

64.4.1. Introduction
64.4.2. Built-in Operator Classes
64.4.3. Extensibility
64.4.4. Implementation
64.4.5. GIN Tips and Tricks
64.4.6. Limitations
64.4.7. Examples

64.5. BRIN Indexes

64.5.1. Introduction
64.5.2. Built-in Operator Classes
64.5.3. Extensibility

64.6. Hash Indexes

64.6.1. Overview
64.6.2. Implementation

Prev	Up	Next
63.2. Custom WAL Resource Managers	Home	64.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.