Re: JSONB performance enhancement for 9.6 - Mailing list pgsql-general

From Thomas Kellerer
Subject Re: JSONB performance enhancement for 9.6
Date
Msg-id n3erdo$cct$1@ger.gmane.org
Whole thread Raw
In response to JSONB performance enhancement for 9.6  (Tom Smith <tomsmith1989sk@gmail.com>)
Responses Re: JSONB performance enhancement for 9.6
List pgsql-general
Tom Smith schrieb am 29.11.2015 um 03:27:
> Hello:
>
> Is there a plan for 9.6 to resolve the issue of very slow query/retrieval of jsonb fields
> when there are large number (maybe several thousands) of top level keys.
> Currently, if I save a large json document with top level keys of thousands and query/retrieve
> field values,  the whole document has to be first decompressed and load to memory
> before searching for the specific field key/value.
>
> Thanks in Advance

If you are concerned about the compression overhead, then why don't you use (or try) JSON instead?




pgsql-general by date:

Previous
From: Francisco Olarte
Date:
Subject: Re: JSONB performance enhancement for 9.6
Next
From: Tom Smith
Date:
Subject: Re: JSONB performance enhancement for 9.6