GIN (Generalized Inverted Index)

An index type suitable for handling composite values and for searching within the composite values

GIN (Generalized Inverted Index) is an index type which supports more complex data types than the usual key/value relationships supported by e.g. btree indexes. Common applications for GIN include indexing array values and full text search.

GIN index support was introduced in PostgreSQL 8.2.

Change history


Full Text Search, Indexing, Performance

See also

GiST, btree_gin, pg_trgm