[GENERAL] temporarily disable autovacuum on a database or server ?

Поиск
Список
Период
Сортировка
От Jonathan Vanasco
Тема [GENERAL] temporarily disable autovacuum on a database or server ?
Дата
Msg-id 8E1E4DA5-1F4E-4D2D-A2BE-B44AF81E5E09@2xlp.com
обсуждение исходный текст
Ответы Re: [GENERAL] temporarily disable autovacuum on a database or server ?  (Melvin Davidson <melvin6925@gmail.com>)
Список pgsql-general
I've run into a performance issue, and I think autovacuum may be involved.

does anyone know if its possible to temporarily stop autovacuum without a server restart ?

It seems that it either requires a server restart, or specific tables to be configured.

Several times a day/week, I run a handful of scripts to handle database maintenance and backups:

    * refreshing materialized views
    * calculating analytics/derived/summary tables and columns
    * backing up the database (pg_dumpall > bz2 > archiving)

These activities have occasionally overlapped with autovacuum, and the performance seems to be affected.




В списке pgsql-general по дате отправления:

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: [GENERAL] ERROR: canceling statement due to statement timeout
Следующее
От: Patrick B
Дата:
Сообщение: Re: [GENERAL] ERROR: canceling statement due to statement timeout