Examples
| PostgreSQL 9.4.12 Documentation | |||
|---|---|---|---|
| Prev | Up | Chapter 56. GiST Indexes | 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:
- 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"