jsonb value retrieval performance

From: Tom Smith <tomsmith1989sk(at)gmail(dot)com>
To: PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject: jsonb value retrieval performance
Date: 2015-09-07 21:40:01
Message-ID: CAKwSVFESQ478zJAGi0FJES+uq3vrLhOwH-cZc21fuMu45wYTTg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Vick Khera 2015-09-07 23:39:47 Re: Partitioning and constraint exclusion
Previous Message David G. Johnston 2015-09-07 20:48:03 Re: Partitioning and constraint exclusion