| From: | Greg Williamson <gwilliamson39(at)yahoo(dot)com> |
|---|---|
| To: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: autovacuum |
| Date: | 2012-12-30 11:30:54 |
| Message-ID: | 1356867054.25225.YahooMailNeo@web125903.mail.ne1.yahoo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Suhas --
>
>Can i cancel ongoing autovacuum on a large table? Is it safe?
>
>I am trying to do pg_cancel_backend(procid).Please suggest whether its safe
>to do ?
>
>Rgrds
>Suhas
>
>
I've killed autovac processes manually with no malign effects other than the consequences of not vacuuming the table involved.
This may depend some on what version of postgres -- that may make a difference. My experience is with 8.4 and 9.1 and both have been OK (although on one database the autovac is set to be very aggressive so it starts again almost immediately. You may need to tweak the config settings if that is the case).
But I have usually found that autovac solves far more problems than it causes.
You may want to post more details about version and config settings related to autovac that differ from defaults. That might help get a better answer, and might help with whatever problem you think autovac is causing.
HTH,
Greg Williamson
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kevin Grittner | 2012-12-30 18:35:59 | Re: Autovacuum issues with truncate and create index ... |
| Previous Message | suhas.basavaraj12 | 2012-12-30 10:30:52 | autovacuum |