Re: Indexing on JSONB field not working
Jeff Janes <[email protected]> Fri, 3 Jan 2020 09:14:48 -0500
| Newsgroups | gmane.comp.db.postgresql.bugs |
|---|---|
| Message-ID | <CAMkU=1xvrdppRC_MX3u65ndrYLr4QuaoRpoRXWOKEOv2YQOdvQ@mail.gmail.com> |
On Thu, Jan 2, 2020 at 5:07 PM Zhihong Zhang <[email protected]> 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.