Skip to content

masterclass Buddy

Sign in Start learning

PostgreSQL · Concept

GiST index

GiST is a balanced tree framework for implementing many index strategies. Its operator class decides which operators and searches the index supports.

Last updated 2 November 2026

Syntax

CREATE INDEX name ON table USING GIST ( column );

In-depth API docs are only for subscribers: parameters, examples, common mistakes and interview practice.

B-tree indexes
SP-GiST indexes
GIN indexes
operator class
consistent
distance
penalty
picksplit

Source: PostgreSQL: Documentation: 18: 65.2. GiST Indexes. Checked 2026-11-03.