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 (commit 8a3631f8; release notes).

Categories

Full Text Search, Indexing, Performance

See also

GiST, btree_gin