GIN index

The GIN (Generalized Inverted Index) index maps each element contained in a composite value to the rows that contain it. It suits jsonb, arrays and full-text search, for operators such as @>, ? or @@. It is fast to read but more costly to write.

Example

CREATE INDEX ON clients USING gin (donnees);

Related concepts

The whole glossary