Using GIN Indexes in YugabyteDB
At Yugabyte, we are committed to complete PostgreSQL compatibility. Similar to PostgreSQL, YugabyteDB supports the following three container column types. These three data types are extremely useful in various cases:
- jsonb – Makes it useful for schema-less data use cases
- tsvector – Supports full text search through a sorted list of distinct lexemes
- array – Gives the flexibility to store a large composite variable-length value in a single field
Each data type’s utility is severely limited without an efficient way to index them.