Skip to content

Glossary: PostgreSQL for Developers

GIN index

Also written: GIN, generalized inverted index

An index type that indexes every key and value inside a jsonb column (and arrays). It speeds up @> and ? searches; create it with USING gin.

Where the book teaches it

Related terms

jsonbcontainmentB-tree