Re: Jsonb first level keys statistic

Поиск
Список
Период
Сортировка
От Michael Lewis
Тема Re: Jsonb first level keys statistic
Дата
Msg-id CAHOFxGp593cbHyopE8_Bv_T1vL8mNXgOR=WhWgBy_nxHa-B82A@mail.gmail.com
обсуждение исходный текст
Ответ на Jsonb first level keys statistic  (Игорь Выскорко <vyskorko.igor@yandex.ru>)
Список pgsql-general
Other than creating a functional index on the keys that you most want to access and include that function call in your query, I don't know that you can. Functional indexes get statistics while partial indexes do not. If a GIN index using path operator collected stats on the frequency of the keys, then you would be all set I think. Perhaps that is a feature that could be implemented.

Others will chime in I expect, but I tend to avoid using jsonb for any values that I need to use to significant filter a result set (ON and WHERE clauses).

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

Предыдущее
От: Игорь Выскорко
Дата:
Сообщение: Jsonb first level keys statistic
Следующее
От: Nicola Contu
Дата:
Сообщение: Re: ERROR: too many dynamic shared memory segments