Re: [GENERAL] temporarily disable autovacuum on a database or server ?
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.
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.
В списке pgsql-general по дате отправления:
Предыдущее
От: Adrian KlaverДата:
Сообщение: Re: [GENERAL] ERROR: canceling statement due to statement timeout
Следующее
От: "David G. Johnston"Дата:
Сообщение: Re: [GENERAL] Means to emulate global temporary table