Re: avtovacuum queue

Hi, Tom, no its not, because during night hours its running autovacuum
vacuum several times automatically,
other strange thing that autovacuum analyze process started today at 5 A.M.
and its still running, maybe thats why autovacuum vacuum never occurs? as i
understand there cant be vacuum and analyze on the same relation at the
same time?
What can be done to speed up analyze on pg_attribute?

Thanks

2018-04-02 19:43 GMT+03:00 Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>:

> "David G. Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> writes:
> > On Mon, Apr 2, 2018 at 8:30 AM, Artem Tomyuk <admin(at)leboutique(dot)com>
> wrote:
> >> i've noticed that during business hours autovacuum vacuum is not being
> >> triggered on pg_attribute,
> >> but during night time it triggered every two hours, both vacuum and
> >> analyze, maybe you know why?
>
> > ​Sounds like someone added a "cron job" somewhere.
>
> ... and, perhaps, explicitly disabled autovacuum on that table?
>
> regards, tom lane
>