Postgres Pro
Downloads
Home   >   mailing lists

Re: avtovacuum queue - Mailing list pgsql-admin

From Artem Tomyuk
Subject Re: avtovacuum queue
Date
Msg-id CANYYVqKXu75wFtvwtVo57fj82Ro7qc3uPCSU8TjsGUbq0z_mGA@mail.gmail.com
Whole thread Raw
In response to Re: avtovacuum queue  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
Tree view
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@sss.pgh.pa.us>:
"David G. Johnston" <david.g.johnston@gmail.com> writes:
> On Mon, Apr 2, 2018 at 8:30 AM, Artem Tomyuk <admin@leboutique.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

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: avtovacuum queue
Next
From: Artem Tomyuk
Date:
Subject: autovacuum on system catalog