Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 145AC632C95 for ; Fri, 30 Apr 2010 14:57:27 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 66375-10 for ; Fri, 30 Apr 2010 17:57:19 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mail.mischievous.org (mischievous.org [207.210.219.161]) by mail.postgresql.org (Postfix) with ESMTP id 56CB063265F for ; Fri, 30 Apr 2010 14:57:20 -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 A999B74456 for ; Fri, 30 Apr 2010 10:57:18 -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: Fri, 30 Apr 2010 10:57:16 -0700 Message-Id: <73FACE25-A114-4F01-857C-F21067ADA1BA@Mischievous.org> 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: 201004/370 X-Sequence-Number: 34464 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 Thanks, Jason