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).
References
- PostgreSQL documentation: GIN indexes
- PostgreSQL documentation: GiST and GIN Index Types
Useful links
- GIN - Just A Kind Of Index - explanation from Cybertec Schönig & Schönig GmbH
- Original developer documentation (outdated)
Categories
See also
GiST, btree_gin