Statements (46)
| Predicate | Object |
|---|---|
| gptkbp:instanceOf |
gptkb: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
|
| 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 |
7
|
| https://www.w3.org/2000/01/rdf-schema#label |
GIN indexes
|