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@xxxxxxxxxxxxx>:
"David G. Johnston" <david.g.johnston@xxxxxxxxx> writes:
> On Mon, Apr 2, 2018 at 8:30 AM, Artem Tomyuk <admin@xxxxxxxxxxxxxx> 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
