Skip to content

Glossary: PostgreSQL Beyond the Basics

GIN

Also written: gin, gin_trgm_ops

An index type that maps each word, trigram or key to the rows containing it. It is used for jsonb, trigram search and full-text search.

Where the book teaches it

Related terms

pg_trgm, trigramtsvector, tsqueryOperator class