| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Chris Hoover" <revoohc(at)gmail(dot)com> |
| Cc: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: How to turn off autovacuum |
| Date: | 2006-03-22 19:35:28 |
| Message-ID: | 18865.1143056128@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
"Chris Hoover" <revoohc(at)gmail(dot)com> writes:
> Question, if I turn on autovacuum in PG 8.1, how do I turn it off?
> The reason behind this question is that we would love to turn it on and try
> it in our production systems. However, if we find that it is causing to
> much i/o load, we need to be able to turn it off on a moments notice with
> out stopping the database.
Not a problem, you can change the autovacuum parameters with just a
SIGHUP to the postmaster, no need to restart anything.
If you really mean you want to kill it NOW, rather than letting the
current autovac pass finish out, I think a SIGINT to the autovac
process will take care of it.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Eisentraut | 2006-03-22 22:48:03 | Re: pgadmin 1.4 + pgsql 8.1.0 |
| Previous Message | Chris Hoover | 2006-03-22 19:10:09 | How to turn off autovacuum |