PostgreSQL 8.3.23 Documentation | ||||
---|---|---|---|---|
Prev | Fast Backward | Chapter 51. GiST Indexes | Fast Forward | Next |
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:
B-Tree equivalent functionality for several data types
Indexing for multidimensional cubes
Module for storing (key, value) pairs
RD-Tree for one-dimensional array of int4 values
Indexing for tree-like structures
Text similarity using trigram matching
Indexing for "float ranges"