pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedTurning off Autovacuum
3+ messages / 2 participants
[nested] [flat]
* Turning off Autovacuum
@ 2007-03-05 16:00 Steven Flatt <steven.flatt@gmail.com>
0 siblings, 1 reply; 3+ messages in thread
From: Steven Flatt @ 2007-03-05 16:00 UTC (permalink / raw)
To: pgsql-performance
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Turning off Autovacuum
@ 2007-03-05 20:26 Tomas Vondra <tv@fuzzy.cz>
parent: Steven Flatt <steven.flatt@gmail.com>
0 siblings, 1 reply; 3+ messages in thread
From: Tomas Vondra @ 2007-03-05 20:26 UTC (permalink / raw)
To: Steven Flatt <steven.flatt@gmail.com>; +Cc: pgsql-performance
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
>
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Turning off Autovacuum
@ 2007-03-05 21:47 Steven Flatt <steven.flatt@gmail.com>
parent: Tomas Vondra <tv@fuzzy.cz>
0 siblings, 0 replies; 3+ messages in thread
From: Steven Flatt @ 2007-03-05 21:47 UTC (permalink / raw)
To: Tomas Vondra <tv@fuzzy.cz>; +Cc: pgsql-performance
Yeah, I'm hoping there's an easier way. I'd have to put several thousand
entries in the pg_autovacuum table only to remove them a few minutes later.
What I really want is to disable the daemon.
Any idea why I can't just simply set autovacuum to off?
Steve
On 3/5/07, Tomas Vondra <tv@fuzzy.cz> wrote:
>
> 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
> >
>
>
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2007-03-05 21:47 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-03-05 16:00 Turning off Autovacuum Steven Flatt <steven.flatt@gmail.com>
2007-03-05 20:26 ` Tomas Vondra <tv@fuzzy.cz>
2007-03-05 21:47 ` Steven Flatt <steven.flatt@gmail.com>
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