Re: Indexing on JSONB field not working

Поиск
Список
Период
Сортировка
От Jeff Janes
Тема Re: Indexing on JSONB field not working
Дата
Msg-id CAMkU=1xvrdppRC_MX3u65ndrYLr4QuaoRpoRXWOKEOv2YQOdvQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Indexing on JSONB field not working  (Zhihong Zhang <zhihong@gmail.com>)
Список pgsql-bugs
Дерево обсуждения
On Thu, Jan 2, 2020 at 5:07 PM Zhihong Zhang <zhihong@gmail.com> wrote:

We have auto-analyze running every night and it didn’t create the stats either.

Auto-analyze (ANALYZE fired by the autovacuum launcher) is automatic.  How can you choose the time at which it runs ("every night")?

Are you doing something non-standard, like dropping autovacuum_analyze_scale_factor every evening and then increasing it again every morning?

I think it’s probably related to the logic that it skips analyzing if not enough records changed.

Yes.  The creation of an index is not something which triggers an auto-analyze.  Perhaps it should.


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

Предыдущее
От: Jeff Janes
Дата:
Сообщение: Re: Indexing on JSONB field not working
Следующее
От: Jeff Janes
Дата:
Сообщение: Re: BUG #16183: PREPARED STATEMENT slowed down by jit