62.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”