GIN

CREATE INDEX idxgin ON api USING GIN (jdoc);

CREATE INDEX gin_idx ON documents_table USING GIN (locations) WITH (fastupdate = off);

• PostgreSQL 18 (Sep 2025) supports parallel builds for GIN indexes, joining B-tree and BRIN indexes in supporting this capability.

See also

• JSON, jq, jid, mlr, JWT, BSON, Miller, Content-type:, application/json, BadJSON, Webhook, jsonc, ndjson, import json, Google Custom Search JSON API, jsonpath, JSON-LD, JSON tree, JSON-RPC, jsonnet, JSON_TABLE, csv2json, json.tool, JSON Patch