Re: jsonb value retrieval performance

From: Teodor Sigaev <teodor(at)sigaev(dot)ru>
To: Tom Smith <tomsmith1989sk(at)gmail(dot)com>, PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject: Re: jsonb value retrieval performance
Date: 2015-09-08 15:58:57
Message-ID: 55EF05C1.3040005@sigaev.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> 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(at)sigaev(dot)ru
WWW: http://www.sigaev.ru/

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Teodor Sigaev 2015-09-08 16:59:38 Re: jsonb value retrieval performance
Previous Message Bill Moran 2015-09-08 15:16:25 Re: Anyone interested in a Pittsburgh-area Postgres users'