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?