PostgreSQL provides the GIN index for composite data types, like the JSONB type. It allows the index to match the keys of JSON objects, so searching in extended_data (e.g. for an import reference) can be done using an index scan.
PostgreSQL provides the GIN index for composite data types, like the JSONB type. It allows the index to match the keys of JSON objects, so searching in extended_data (e.g. for an import reference) can be done using an index scan.