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

Поиск
Список
Период
Сортировка
Искать
От
Melvin Davidson
Тема
Re: [GENERAL] temporarily disable autovacuum on a database or server ?
Дата
Msg-id
CANu8FiwWpzsDZqCFy3heFf4qy873kRL+LMeBKcbYgDfzrHfLrQ@mail.gmail.com
Ответ на
[GENERAL] temporarily disable autovacuum on a database or server ? (Jonathan Vanasco)
Список
Дерево обсуждения
[GENERAL] temporarily disable autovacuum on a database or server ? Jonathan Vanasco <postgres@2xlp.com>
Re: [GENERAL] temporarily disable autovacuum on a database or server ? Melvin Davidson <melvin6925@gmail.com>
Re: [GENERAL] temporarily disable autovacuum on a database or server ? "David G. Johnston" <david.g.johnston@gmail.com>
Re: [GENERAL] temporarily disable autovacuum on a database or server ? Melvin Davidson <melvin6925@gmail.com>
Re: [GENERAL] temporarily disable autovacuum on a database or server ? Jonathan Vanasco <postgres@2xlp.com>
Re: [GENERAL] temporarily disable autovacuum on a database or server ? Melvin Davidson <melvin6925@gmail.com>
Re: [GENERAL] temporarily disable autovacuum on a database or server ? "David G. Johnston" <david.g.johnston@gmail.com>


On Wed, Jan 11, 2017 at 7:26 PM, Jonathan Vanasco <postgres@2xlp.com> wrote:
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.




--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

I can't confirm this, but have you tried :

SELECT set_config('autovacuum', 'off'', false);
SELECT pg_reload_conf();

note: you must be a superuser for above
--
Melvin Davidson
I reserve the right to fantasize.  Whether or not you
wish to share my fantasy is entirely up to you.
В списке pgsql-general по дате отправления
Предыдущее
От: Adrian Klaver
Дата:
Следующее
От: David G. Johnston
Дата:
FAQ