X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id D1490D1D205 for ; Thu, 29 Jan 2004 13:07:53 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 15422-04 for ; Thu, 29 Jan 2004 09:07:31 -0400 (AST) Received: from wolff.to (wolff.to [66.93.249.74]) by svr1.postgresql.org (Postfix) with SMTP id 7360BD1B449 for ; Thu, 29 Jan 2004 09:07:21 -0400 (AST) Received: (qmail 24168 invoked by uid 500); 29 Jan 2004 13:08:47 -0000 Date: Thu, 29 Jan 2004 07:08:47 -0600 From: Bruno Wolff III To: Iain Cc: pgsql-admin@postgresql.org Subject: Re: Routine maintenance - vacuum, analyse and autovacuum Message-ID: <20040129130847.GC17068@wolff.to> Mail-Followup-To: Iain , pgsql-admin@postgresql.org References: <000901c3e64e$9611c390$7201a8c0@mst1x5r347kymb> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <000901c3e64e$9611c390$7201a8c0@mst1x5r347kymb> User-Agent: Mutt/1.5.4i X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200401/265 X-Sequence-Number: 12128 On Thu, Jan 29, 2004 at 18:59:28 +0900, Iain wrote: I haven't used auto_vacuum, but I seen comments on the lists indicating that it works OK. > If I start a VACUUM FULL, is it ok to interrupt it part way through? I mean, > is a partially completed vacuum full worth anything, and is there any danger > in routinely killing it? With 7.4 you shouldn't have to do VACUUM FULL. If you have FSM set high enough, then normal VACUUM should suffice. The exception would be if you ran something that may the DB much larger than normal and you wanted to shrink the space used by the DB. Then you would need to run a VACUUM FULL.