GIN indexes

GPTKB entity

Statements (46)
Predicate Object
gptkbp:instanceOf Database index type
gptkbp:access inverted index
gptkbp:advantage fast lookups for multi-valued data
slower writes compared to B-tree
gptkbp:canBe partial
concurrent
unique
expression index
multi-column
used with ? operator
used with ?& operator
used with ?| operator
used with @> operator
used with @@ operator
used with WHERE clause
gptkbp:commanded CREATE INDEX ... USING GIN
gptkbp:contrastsWith gptkb:GiST_indexes
gptkbp:distinctFrom gptkb:B-tree_indexes
gptkbp:documentation https://www.postgresql.org/docs/current/gin-intro.html
https://www.w3.org/2000/01/rdf-schema#label GIN indexes
gptkbp:introducedIn PostgreSQL 8.2
gptkbp:limitation higher memory usage
not suitable for range queries
slower index creation
gptkbp:maintenance ANALYZE
REINDEX
VACUUM
gptkbp:performanceTip Consider fastupdate parameter
Consider fillfactor for large updates
Consider maintenance_work_mem
gptkbp:standsFor Generalized Inverted Index
gptkbp:supports full-text search
array columns
hstore columns
jsonb columns
tsvector columns
gptkbp:supportsOperatorClass array_ops
hstore_ops
jsonb_ops
tsvector_ops
gptkbp:usedFor document search
tag search
containment queries
gptkbp:usedIn gptkb:PostgreSQL
gptkbp:bfsParent gptkb:pg_trgm_extension
gptkbp:bfsLayer 6