Re: avtovacuum queue

Поиск
Список
Период
Сортировка
От Artem Tomyuk
Тема Re: avtovacuum queue
Дата
Msg-id CANYYVqKXu75wFtvwtVo57fj82Ro7qc3uPCSU8TjsGUbq0z_mGA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: avtovacuum queue  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-admin
Дерево обсуждения
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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: avtovacuum queue
Следующее
От: Artem Tomyuk
Дата:
Сообщение: autovacuum on system catalog