From: Greg Williamson <gwilliamson39@yahoo.com>
To: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: autovacuum
Date: Sun, 30 Dec 2012 03:30:54 -0800 (PST)
Message-ID: <1356867054.25225.YahooMailNeo@web125903.mail.ne1.yahoo.com> (raw)
In-Reply-To: <1356863452778-5738332.post@n5.nabble.com>
References: <1356863452778-5738332.post@n5.nabble.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-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
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
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-admin@postgresql.org
Cc: gwilliamson39@yahoo.com
Subject: Re: autovacuum
In-Reply-To: <1356867054.25225.YahooMailNeo@web125903.mail.ne1.yahoo.com>
* 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