Postgres Pro
Downloads
Home   >   mailing lists

Re: jsonb value retrieval performance - Mailing list pgsql-general

From Teodor Sigaev
Subject Re: jsonb value retrieval performance
Date
Msg-id 55EF05C1.3040005@sigaev.ru
Whole thread Raw
In response to jsonb value retrieval performance  (Tom Smith <tomsmith1989sk@gmail.com>)
Responses Re: jsonb value retrieval performance
Re: jsonb value retrieval performance
List pgsql-general
Tree view 
> 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?

Suppose, most time is spent for decompressing huge value, not for actual search
inside jsonb. If so, we need to implement some search method which decompress
some chunks of jsonb.


Could you send to me an example of that jsonb?



--
Teodor Sigaev                                   E-mail: teodor@sigaev.ru
                                                    WWW: http://www.sigaev.ru/

pgsql-general by date:

Previous
From: Bill Moran
Date:
Subject: Re: Anyone interested in a Pittsburgh-area Postgres users'
Next
From: Teodor Sigaev
Date:
Subject: Re: jsonb value retrieval performance