Postgres Pro
Downloads
Home   >   mailing lists

jsonb value retrieval performance - Mailing list pgsql-general

From Tom Smith
Subject jsonb value retrieval performance
Date
Msg-id CAKwSVFESQ478zJAGi0FJES+uq3vrLhOwH-cZc21fuMu45wYTTg@mail.gmail.com
Whole thread Raw
Responses Re: jsonb value retrieval performance
List pgsql-general
Tree view
Hello:

Does JSONB storage has some internal indexing(like hasmap)
to fast look up a value given a key?
I have a jsonb doc with two level keys
(parentKey: {childKey:value}}
there are maybe 2000 parent keys per doc and 100 child keys per parent key

and I am trying to get value via  jsonb->parentKey->childKey
it seems it is very slow. 
Would it be actually faster to use top level key only and parse it at client side?

Thanks



pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Partitioning and constraint exclusion
Next
From: Vick Khera
Date:
Subject: Re: Partitioning and constraint exclusion