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 8.3.23 Documentation
Prev	Fast Backward	Chapter 52. GIN Indexes	Fast Forward	Next

52.6. Examples

The PostgreSQL source distribution includes GIN operator classes for tsvector and for one-dimensional arrays of all internal types. The following contrib modules also contain GIN operator classes:

hstore: Module for storing (key, value) pairs
intarray: Enhanced support for int4[]
pg_trgm: Text similarity using trigram matching

Prev	Home	Next
Limitations	Up	Database Physical Storage