X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id BB8FA9DC9FB for ; Wed, 18 Jan 2006 14:23:47 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 95886-10 for ; Wed, 18 Jan 2006 14:23:47 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from exchange.g2switchworks.com (mail.g2switchworks.com [63.87.162.25]) by postgresql.org (Postfix) with ESMTP id 4F55D9DC99E for ; Wed, 18 Jan 2006 14:23:45 -0400 (AST) Received: from 10.10.1.37 ([10.10.1.37]) by exchange.g2switchworks.com ([10.10.1.2]) with Microsoft Exchange Server HTTP-DAV ; Wed, 18 Jan 2006 18:23:45 +0000 Received: from state.g2switchworks.com by mail.g2switchworks.com; 18 Jan 2006 12:23:45 -0600 Subject: Re: effects of cancelling a vacuum full From: Scott Marlowe To: Anjan Dave Cc: pgsql-admin@postgresql.org In-Reply-To: <4BAFBB6B9CC46F41B2AD7D9F4BBAF78504015D89@vt-pe2550-001.vantage.vantage.com> References: <4BAFBB6B9CC46F41B2AD7D9F4BBAF78504015D89@vt-pe2550-001.vantage.vantage.com> Content-Type: text/plain Content-Transfer-Encoding: 7bit Message-Id: <1137608625.25500.83.camel@state.g2switchworks.com> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.6 (1.4.6-2) Date: Wed, 18 Jan 2006 12:23:45 -0600 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.126 required=5 tests=[AWL=0.125, UNPARSEABLE_RELAY=0.001] X-Spam-Score: 0.126 X-Spam-Level: X-Archive-Number: 200601/193 X-Sequence-Number: 20281 On Wed, 2006-01-18 at 12:17, Anjan Dave wrote: > Hi, > > I just had to cancel one VACUUM FULL (of a 4.3m row table) that someone ran in business hours. It was after an hour or so that I realized, and it was blocking queries, running out of connections, so I cancelled it. Are there any bad side effects of cancelling an ongoing full vacuum of a table or a database? Does a partial full vacuum give back any space? > No damage done. No space returned. Just wait and run it again later. Tell your used to do a vacuum regular during business hours or you'll have to give him a stern talking to.