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
|