PostgreSQL · Concept

GIN index

A GIN index searches for elements inside composite values, such as array members or document terms. It stores each key once and maps it to rows containing that key.

Last updated 2 November 2026

Since

9.1

CREATE INDEX index_name ON table_name USING GIN (column_name);

Source: PostgreSQL: Documentation: 18: 65.4. GIN Indexes. Checked 2026-11-03.