Postgres-XC 1.0.3 Documentation
PrevFast BackwardChapter 54. GIN IndexesFast ForwardNext

54.6. Examples

Note: The following description applies both to Postgres-XC and PostgreSQL if not described explicitly.

The Postgres-XC source distribution includes GIN operator classes for tsvector and for one-dimensional arrays of all internal types. Prefix searching in tsvector is implemented using the GIN partial match feature. The following contrib modules also contain GIN operator classes:

btree_gin

B-tree equivalent functionality for several data types

hstore

Module for storing (key, value) pairs

intarray

Enhanced support for int[]

pg_trgm

Text similarity using trigram matching

PrevHomeNext
LimitationsUpDatabase Physical Storage