Re: reclaiming disk space after major updates - Mailing list pgsql-admin

From Andrew Sullivan
Subject Re: reclaiming disk space after major updates
Date
Msg-id 20070608140354.GV17144@phlogiston.dyndns.org
Whole thread Raw
In response to Re: reclaiming disk space after major updates  (Dan Harris <fbsd@drivefaster.net>)
List pgsql-admin
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

pgsql-admin by date:

Previous
From: "Charles.Hou"
Date:
Subject: Re: the right time to vacuum database?
Next
From: Andrew Sullivan
Date:
Subject: Re: the right time to vacuum database?