Gin (Generalized Inverted Index)
PostgreSQL Full Text Search Gin (Generalized Inverted Index) Index
Full Text Search
PostgreSQL Index: Full Text Search
Categories:
GIN (Generalized Inverted Index) based index
CREATE INDEX name ON table USING GIN (column);
Scenario
- array
- json object
Data type
- hstore
- json
- jsonb
GiST (Generalized Search Tree) based index
Reference
- PostgreSQL: Documentation: 15: Chapter 12. Full Text Search
- PostgreSQL: Documentation: 15: 12.9. Preferred Index Types for Text Search
- PostgreSQL: Documentation: 15: Chapter 68. GiST Indexes
- PostgreSQL: Documentation: 15: Chapter 70. GIN Indexes
- Gist Index - PostgreSQL: Documentation: 15: 68.2. Built-in Operator Classes
- Gin Index - PostgreSQL: Documentation: 15: 70.2. Built-in Operator Classes