Re: Indexing on JSONB field not working

Поиск
Список
Период
Сортировка
От Zhihong Zhang
Тема Re: Indexing on JSONB field not working
Дата
Msg-id CE20A918-FDF4-4D43-A969-6CBB70B69164@gmail.com
обсуждение исходный текст
Ответ на Re: Indexing on JSONB field not working  (Jeff Janes <jeff.janes@gmail.com>)
Ответы Re: Indexing on JSONB field not working  (Tomas Vondra <tomas.vondra@2ndquadrant.com>)
Re: Indexing on JSONB field not working  (Jeff Janes <jeff.janes@gmail.com>)
Список pgsql-bugs

Only one of your indexes is over an expression.  The index over a plain column will never have stats, as column stats are stored with the table, not the index.


Oh. That explains it. I tweaked a few server parameters, wonder if that made the difference. I changed,

pg_stat_statements.track: ALL

track_activity_query_size: 2048

Now we have stats, can anyone see why the index is not used?

Thanks!

Zhihong

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

Предыдущее
От: Jeff Janes
Дата:
Сообщение: Re: Indexing on JSONB field not working
Следующее
От: Tomas Vondra
Дата:
Сообщение: Re: Indexing on JSONB field not working