GIN indexes speed up full-text and multi-value search
A GIN index stores searchable keys extracted from values and maps those keys to rows. Full-text documents, arrays, and JSONB can all use this access method, but each indexed expression needs an appropriate operator class. GIN is a family of supported searches, not one index that automatically accelerates unrelated columns, data types, or predicates. ...