On Wed, Jan 11, 2017 at 7:26 PM, Jonathan Vanasco <postg...@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.