Sample Header Ad - 728x90

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