Re: JsonB Gin Index is very large; is there a work around?

Поиск
Список
Период
Сортировка
От Larry White
Тема Re: JsonB Gin Index is very large; is there a work around?
Дата
Msg-id CAMdbzVi2Carg+ghBq650Z1=r-CJE4zMN8KPd6hMsyG8MhOvDCA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: JsonB Gin Index is very large; is there a work around?  (Peter Geoghegan <peter.geoghegan86@gmail.com>)
Список pgsql-general
Дерево обсуждения
Ok Thank you.

FWIW, the documents (which I can't share) consist mainly of a long list of integers in the form {"n":"41515920318427252715"}, so they really are outliers.


On Wed, Aug 20, 2014 at 5:09 PM, Peter Geoghegan <peter.geoghegan86@gmail.com> wrote:
On Wed, Aug 20, 2014 at 1:53 PM, Larry White <ljw1001@gmail.com> wrote:
> Is there anyway to index a subset of the data in a JSONB column? I'm
> thinking of something like declaring certain paths to be indexed?


Yes. See the expression index example in the jsonb documentation.

--
Regards,
Peter Geoghegan

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

Предыдущее
От: Peter Geoghegan
Дата:
Сообщение: Re: JsonB Gin Index is very large; is there a work around?
Следующее
От: Ramesh T
Дата:
Сообщение: Re: POWA tool