Re: avtovacuum queue

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
Cc: Artem Tomyuk <admin(at)leboutique(dot)com>, pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: avtovacuum queue
Date: 2018-04-02 16:43:03
Message-ID: 32644.1522687383@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

"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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Artem Tomyuk 2018-04-03 08:51:07 Re: avtovacuum queue
Previous Message David G. Johnston 2018-04-02 15:34:39 Re: avtovacuum queue