Examples
| PostgreSQL 9.6.24 Documentation | |||
|---|---|---|---|
| Prev | Up | Chapter 61. 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"