Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 0BAF39FB52D for ; Fri, 8 Jun 2007 11:04:06 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 00860-08 for ; Fri, 8 Jun 2007 11:03:54 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from main2.mycybernet.net (main2.mycybernet.net [209.222.63.140]) by postgresql.org (Postfix) with ESMTP id 794F09FB3DB for ; Fri, 8 Jun 2007 11:04:02 -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 1Hwf4J-00008z-Kl for pgsql-admin@postgresql.org; Fri, 08 Jun 2007 10:03:59 -0400 Received: by phlogiston.dydns.org (Postfix, from userid 1000) id 5131A3FAF; Fri, 8 Jun 2007 10:03:54 -0400 (EDT) Date: Fri, 8 Jun 2007 10:03:54 -0400 From: Andrew Sullivan To: pgsql-admin@postgresql.org Subject: Re: reclaiming disk space after major updates Message-ID: <20070608140354.GV17144@phlogiston.dyndns.org> References: <46672F7C.4020400@drivefaster.net> <20070607192025.GO14087@phlogiston.dyndns.org> <46687820.9000604@drivefaster.net> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <46687820.9000604@drivefaster.net> User-Agent: Mutt/1.5.9i X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200706/82 X-Sequence-Number: 25750 On Thu, Jun 07, 2007 at 03:26:56PM -0600, Dan Harris wrote: > > They don't always have to be in a single transaction, that's a good idea to > break it up and vacuum in between, I'll consider that. Thanks If you can do it this way, it helps _a lot_. I've had to do this sort of thing, and breaking into groups of a couple thousand or so really made the difference. A -- Andrew Sullivan | ajs@crankycanuck.ca Unfortunately reformatting the Internet is a little more painful than reformatting your hard drive when it gets out of whack. --Scott Morris