September 25, 2025: PostgreSQL 18 Released!

Supported Versions: 16 / 15 / 14 / 13

Unsupported versions: 12 / 11 / 10 / 9.6 / 9.5 / 9.4 / 9.3 / 9.2 / 9.1 / 9.0 / 8.4 / 8.3 / 8.2

This documentation is for an unsupported version of PostgreSQL.
You may want to view the same page for the current version, or one of the other supported versions listed above instead.

PostgreSQL 9.6.24 Documentation
Prev	Up	Chapter 63. GIN Indexes	Next

63.7. Examples

The PostgreSQL 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

Prev	Home	Next
Limitations	Up	BRIN Indexes