Gin (Generalized Inverted Index)

https://www.postgresql.org/docs/current/gin.html

CREATE INDEX name ON table USING GIN (column);

Scenario

• array
• json object

Data type

• hstore
• json
• jsonb

Built-in Operator Classes

https://www.postgresql.org/docs/current/gin-builtin-opclasses.html

array_ops

jsonb_ops

jsonb_path_ops

tsvector_ops

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
• Gist Implementation - PostgreSQL: Documentation: 15: 68.4. Implementation
• Gin Implementation - PostgreSQL: Documentation: 15: 70.4. Implementation