| From: | "Steven Flatt" <steven(dot)flatt(at)gmail(dot)com> |
|---|---|
| To: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Turning off Autovacuum |
| Date: | 2007-03-05 16:00:48 |
| Message-ID: | 357fa7590703050800u5954e55fyc806ee19fb1f161@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2007-03-05 16:02:31 | Re: Aggressive freezing in lazy-vacuum |
| Previous Message | A. Kretschmer | 2007-03-05 15:34:51 | Re: Estimate the size of the SQL file generated by pg_dump utility |