Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from
	<pgsql-admin-owner+M40548=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
	id 1TpGAW-0005np-US
	for pgsql-admin@arkaria.postgresql.org; Sun, 30 Dec 2012 10:31:01 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
	by malur.postgresql.org with smtp (Exim 4.72) (envelope-from
	<pgsql-admin-owner+M40548=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
	id 1TpGAU-0003Wc-R7
	for pgsql-admin@arkaria.postgresql.org; Sun, 30 Dec 2012 10:30:58 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <suhas.b@verse.in>) id 1TpGAS-0003WU-Tj
	for pgsql-admin@postgresql.org; Sun, 30 Dec 2012 10:30:56 +0000
Received: from sam.nabble.com ([216.139.236.26])
	by magus.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <suhas.b@verse.in>) id 1TpGAR-00010g-8l
	for pgsql-admin@postgresql.org; Sun, 30 Dec 2012 10:30:56 +0000
Received: from [192.168.236.26] (helo=sam.nabble.com)
	by sam.nabble.com with esmtp (Exim 4.72)
	(envelope-from <suhas.b@verse.in>) id 1TpGAO-0002KU-Q3
	for pgsql-admin@postgresql.org; Sun, 30 Dec 2012 02:30:52 -0800
Date: Sun, 30 Dec 2012 02:30:52 -0800 (PST)
From: "suhas.basavaraj12" <suhas.b@verse.in>
To: pgsql-admin@postgresql.org
Message-ID: <1356863452778-5738332.post@n5.nabble.com>
Subject: autovacuum
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Pg-Spam-Score: -0.8 (/)
List-Archive: <http://archives.postgresql.org/pgsql-admin>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-admin.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@postgresql.org>
List-Post: <mailto:pgsql-admin@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-admin>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
X-Mailing-List: pgsql-admin
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

Hi,

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



--
View this message in context: http://postgresql.1045698.n5.nabble.com/autovacuum-tp5738332.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.


-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin