X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 966BC5334B for ; Mon, 18 Apr 2005 16:38:52 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 54338-10 for ; Mon, 18 Apr 2005 19:38:51 +0000 (GMT) Received: from wolff.to (wolff.to [66.93.197.194]) by svr1.postgresql.org (Postfix) with SMTP id 25C945339C for ; Mon, 18 Apr 2005 16:38:50 -0300 (ADT) Received: (qmail 5431 invoked by uid 500); 18 Apr 2005 19:58:19 -0000 Date: Mon, 18 Apr 2005 14:58:19 -0500 From: Bruno Wolff III To: Bill Chandler Cc: pgsql-perform Subject: Re: Question on vacuumdb Message-ID: <20050418195819.GB4961@wolff.to> Mail-Followup-To: Bruno Wolff III , Bill Chandler , pgsql-perform References: <20050418192708.51229.qmail@web51407.mail.yahoo.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20050418192708.51229.qmail@web51407.mail.yahoo.com> User-Agent: Mutt/1.5.6i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.009 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200504/435 X-Sequence-Number: 11832 On Mon, Apr 18, 2005 at 12:27:08 -0700, Bill Chandler wrote: > All, > > If I run the command "vacuumdb mydb" I understand that > it does some disk space recovery (but not as much as > "vacuumdb --full mydb"). You are better off not using vacuum full unless some unusual event has bloated your database. By running normal vacuums often enough (and with a large enough fsm setting) your database should reach a steady state size. > Question: if I run the command "vacuumdb --analyze > mydb" does it still do the aforementioned disk space > recovery AS WELL AS update query planning statistics? > Or are those two completely separate operations > requiring separate invocations of 'vacuumdb'. It is better to do both with one command.