What Is GIN Index?
GIN (Generalized Inverted Index) is used for indexing array values, JSONB, and full-text search. It supports fast retrieval for elements within composite data. GIN trades slower writes for quicker queries.
Why It Matters for PostgreSQL Performance
In PostgreSQL performance work, GIN Index affects throughput, latency, or operational reliability depending on workload and configuration.
Practical Benchmarking Context
When benchmarking with pgbench, track how GIN Index changes behavior across scale factor, client concurrency, and storage conditions.
Use this term together with workload shape, concurrency level, and scale factor when interpreting pgbench outputs. Isolated values can be misleading without full run context.
Example
Command: CREATE INDEX ON documents USING gin(tags);