Postgres Pro
Downloads
Home   >   mailing lists

Re: Indexing on JSONB field not working - Mailing list pgsql-bugs

From Jeff Janes
Subject Re: Indexing on JSONB field not working
Date
Msg-id CAMkU=1xvrdppRC_MX3u65ndrYLr4QuaoRpoRXWOKEOv2YQOdvQ@mail.gmail.com
Whole thread Raw
In response to Re: Indexing on JSONB field not working  (Zhihong Zhang <zhihong@gmail.com>)
List pgsql-bugs
Tree view
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 by date:

Previous
From: Jeff Janes
Date:
Subject: Re: Indexing on JSONB field not working
Next
From: Jeff Janes
Date:
Subject: Re: BUG #16183: PREPARED STATEMENT slowed down by jit