JSONB performance enhancement for 9.6

From: Tom Smith <tomsmith1989sk(at)gmail(dot)com>
To: PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject: JSONB performance enhancement for 9.6
Date: 2015-11-29 02:27:51
Message-ID: CAKwSVFG4epGaNvH5CuS12ihRL6BocRzV7HD+yvhYw=5s5krP4Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John R Pierce 2015-11-29 05:37:41 Re: JSONB performance enhancement for 9.6
Previous Message John J. Turner 2015-11-28 20:00:29 Re: DISTINCT in STRING_AGG