What should I choose between jsonb array and jsonb map for faster querying?
0
votes
0
answers
458
views
I have a jsonb column which will consist of some keys and the rows will be searchable using those keys. Considering that I will be applying GIN index on the jsonb column what should be the ideal structure for faster lookups ? A jsonb array consisting of all the items or a jsonb map where the items will be the keys.
Asked by user2375245
(1 rep)
Sep 8, 2022, 05:46 PM