JSONB performance enhancement for 9.6

Поиск
Список
Период
Сортировка
От Tom Smith
Тема JSONB performance enhancement for 9.6
Дата
Msg-id CAKwSVFG4epGaNvH5CuS12ihRL6BocRzV7HD+yvhYw=5s5krP4Q@mail.gmail.com
обсуждение исходный текст
Ответы Re: JSONB performance enhancement for 9.6  (John R Pierce <pierce@hogranch.com>)
Re: JSONB performance enhancement for 9.6  (Bill Moran <wmoran@potentialtech.com>)
Re: JSONB performance enhancement for 9.6  (Thomas Kellerer <spam_eater@gmx.net>)
Список 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





В списке pgsql-general по дате отправления:

Предыдущее
От: "John J. Turner"
Дата:
Сообщение: Re: DISTINCT in STRING_AGG
Следующее
От: John R Pierce
Дата:
Сообщение: Re: JSONB performance enhancement for 9.6