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

51.6. Examples

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

intarray: Enhanced support for int4[]
tsearch2: Support for inverted text indexing. This is much faster for very large, mostly-static sets of documents.

Prev	Home	Next
Limitations	Up	Database Physical Storage