The PostgreSQL source distribution includes several examples of index methods implemented using GiST. The core system currently provides text search support (indexing for tsvector
and tsquery
) as well as R-Tree equivalent functionality for some of the built-in geometric data types (see src/backend/access/gist/gistproc.c
). The following contrib
modules also contain GiST operator classes:
btree_gist
-
B-tree equivalent functionality for several data types
cube
-
Indexing for multidimensional cubes
hstore
-
Module for storing (key, value) pairs
intarray
-
RD-Tree for one-dimensional array of int4 values
ltree
-
Indexing for tree-like structures
pg_trgm
-
Text similarity using trigram matching
seg
-
Indexing for "float ranges"
Prev | Next | |
Implementation | Up | SP-GiST Indexes |
Please login to continue.