Home > mailing lists

JSONB performance enhancement for 9.6 - Mailing list pgsql-general

From	Tom Smith
Subject	JSONB performance enhancement for 9.6
Date	November 29, 2015 05:28:04
Msg-id	CAKwSVFG4epGaNvH5CuS12ihRL6BocRzV7HD+yvhYw=5s5krP4Q@mail.gmail.com Whole thread Raw
Responses	Re: JSONB performance enhancement for 9.6 Re: JSONB performance enhancement for 9.6 Re: JSONB performance enhancement for 9.6
List	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

From: "John J. Turner"
Date: 28 November 2015, 23:00:38
Subject: Re: DISTINCT in STRING_AGG

From: John R Pierce
Date: 29 November 2015, 08:37:55
Subject: Re: JSONB performance enhancement for 9.6