pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: Tomas Vondra <tv@fuzzy.cz>
To: Steven Flatt <steven.flatt@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Turning off Autovacuum
Date: Mon, 05 Mar 2007 21:26:45 +0100
Message-ID: <45EC7D05.60204@fuzzy.cz> (raw)
In-Reply-To: <357fa7590703050800u5954e55fyc806ee19fb1f161@mail.gmail.com>
References: <357fa7590703050800u5954e55fyc806ee19fb1f161@mail.gmail.com>

If you want to disable it only for some tables, you can put special 
values into pg_autovacuum. This won't disable the autovacuum daemon, but 
some of the tables won't be vacuumed.

Tomas
> Not quite a performance question, but I can't seem to find a simple 
> answer to this.  We're using 8.1.4 and the autovacuum daemon is 
> running every 40 seconds cycling between 3 databases.  What is the 
> easiest way to disable the autovacuumer for a minute or two, do some 
> other work, then re-enable it?  Do I have to modify postgresql.conf 
> and send a HUP signal to pick up the changes? 
>  
> I figured this would work but I can't find a reason why not:
>  
> # show autovacuum;
>  autovacuum
> ------------
>  on
> (1 row)
>
> # set autovacuum to off;
> ERROR:  parameter "autovacuum" cannot be changed now
>
> In postgresql.conf:
>
> autovacuum = on
>
> Thanks,
>
> Steve
>

view thread (3+ messages)  latest in thread

Message-ID: <45EC7D05.60204@fuzzy.cz>
Permalink:  ../45EC7D05.60204@fuzzy.cz/
Also on:    postgresql.org/message-id/45EC7D05.60204@fuzzy.cz

copy link · copy postgr.es

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: tv@fuzzy.cz, steven.flatt@gmail.com
  Subject: Re: Turning off Autovacuum
  In-Reply-To: <45EC7D05.60204@fuzzy.cz>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox