On a test instance identifiers was converted from text to JSONB and indexed using a GIN index. Performance for locating records with a specific identifier dropped to a couple ms vs. several seconds.
Need to review where this content is used to see what benefits may be had by changing the type.
https://github.com/isamplesorg/isamples_inabox/blob/1dd737be80401497b9d60db1b2c23c30a206b2c3/isb_lib/models/thing.py#L79
On a test instance identifiers was converted from text to JSONB and indexed using a GIN index. Performance for locating records with a specific identifier dropped to a couple ms vs. several seconds.
Need to review where this content is used to see what benefits may be had by changing the type.