Re: JSONB performance enhancement for 9.6

On 11/28/2015 6:27 PM, Tom Smith wrote:
> 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.

If it was my data, I'd be decomposing that large JSON thing into
multiple SQL records, and storing as much stuff as possible in named SQL
fields, using JSON in the database only for things that are too
ambiguous for SQL.



--
john r pierce, recycling bits in santa cruz