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? -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
