61.5. Examples

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

© 1996–2019 The PostgreSQL Global Development Group
Licensed under the PostgreSQL License.
https://www.postgresql.org/docs/9.6/gist-examples.html