Received: from maia.hub.org (maia-4.hub.org [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 80310633861 for ; Thu, 29 Apr 2010 15:02:18 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 54657-03 for ; Thu, 29 Apr 2010 18:02:11 +0000 (UTC) X-Greylist: delayed 00:06:57.06463 by SQLgrey-1.7.6 Received: from mail.mischievous.org (mischievous.org [207.210.219.161]) by mail.postgresql.org (Postfix) with ESMTP id B9E33633D01 for ; Thu, 29 Apr 2010 15:02:07 -0300 (ADT) Received: from rainmaker.merchantcircle.com (mx.merchantcircle.com [66.201.45.122]) (using TLSv1 with cipher AES128-SHA (128/128 bits)) (No client certificate requested) by mail.mischievous.org (Postfix) with ESMTPSA id 52A7A74456 for ; Thu, 29 Apr 2010 10:55:08 -0700 (PDT) From: Jason Culverhouse Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: quoted-printable Subject: Can I safely kill a VACUUM ANALYZE with pg_cancel_backend 8.3 Date: Thu, 29 Apr 2010 10:55:08 -0700 Message-Id: To: pgsql-admin@postgresql.org Mime-Version: 1.0 (Apple Message framework v1078) X-Mailer: Apple Mail (2.1078) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.91 tagged_above=-10 required=5 tests=BAYES_00=-1.9, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201005/30 X-Sequence-Number: 34503 HI,=20 I have a vacuum process that has been running on a table for the past 20 = days. The server is postgres 8.3 on ubuntu linux. Can I safely kill the vacuum with: select pg_cancel_backend(26433) Some stats The table sees ~5million and not more than ~10million updates month $ ps aux | grep 26433 postgres 26433 0.0 1.5 35468848 2012212 ? Ss Apr08 26:00 = postgres: autovacuum worker process foo foo=3D# select procpid, now() - query_start, query_start, current_query = from pg_stat_activity where current_query !=3D ''order by 1 desc; procpid | ?column? | query_start | = current_query = =20 = ---------+-------------------------+-------------------------------+------= --------------------------------------------------------------------------= ------------------------------------------------------- 26433 | 20 days 20:11:32.386244 | 2010-04-08 14:19:59.298784-07 | = autovacuum: VACUUM ANALYZE public.message =20 Thanks, Jason =20