X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id AA49A9FA5E2 for ; Tue, 30 May 2006 11:58:44 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 25061-06 for ; Tue, 30 May 2006 11:58:35 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from main2.mycybernet.net (main2.mycybernet.net [209.222.63.140]) by postgresql.org (Postfix) with ESMTP id 878B29FA5E6 for ; Tue, 30 May 2006 11:58:35 -0300 (ADT) Received: from 227-54-222-209.mycybernet.net ([209.222.54.227] helo=phlogiston.dydns.org) by main2.mycybernet.net with esmtp (Exim 4.62) (envelope-from ) id 1Fl5j9-0004HZ-Hf for pgsql-admin@postgresql.org; Tue, 30 May 2006 11:01:47 -0400 Received: by phlogiston.dydns.org (Postfix, from userid 1000) id 6D8044051; Tue, 30 May 2006 10:58:28 -0400 (EDT) Date: Tue, 30 May 2006 10:58:28 -0400 From: Andrew Sullivan To: pgsql-admin@postgresql.org Subject: Re: full vacuum - resources - scaling Message-ID: <20060530145828.GB20300@phlogiston.dyndns.org> References: Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.5.9i X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200605/412 X-Sequence-Number: 21944 On Tue, May 30, 2006 at 09:44:22AM -0400, Mr. Dan wrote: > Hi, > > I have noticed that my full vacuum and re-index script is taking a day and > a half instead of 1/2 day. > Recently, the size of my database cluster has doubled to 130 GB. Would > anyone recommend increasing one or more of these to help get my full > vacuums to run a little faster? What Alvaro said. I'll also point out, however, that in my experience, VACUUM FULL time does not increase linearly with database size. I suspect this is because of the cost of reorganising so much more data, but I haven't done any real analysis of it. The main thing is, "Don't do vacuum full." A -- Andrew Sullivan | ajs@crankycanuck.ca The whole tendency of modern prose is away from concreteness. --George Orwell