Postgres Pro 9.5.12.1 Documentation | |||
---|---|---|---|
Prev | Up | Chapter 59. GiST Indexes | Next |
59.5. Examples
The Postgres Pro 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"