Re: reclaiming disk space after major updates

From: Andrew Sullivan <ajs(at)crankycanuck(dot)ca>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: reclaiming disk space after major updates
Date: 2007-06-08 14:03:54
Message-ID: 20070608140354.GV17144@phlogiston.dyndns.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-performance

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(at)crankycanuck(dot)ca
Unfortunately reformatting the Internet is a little more painful
than reformatting your hard drive when it gets out of whack.
--Scott Morris

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Andrew Sullivan 2007-06-08 14:20:30 Re: the right time to vacuum database?
Previous Message Charles.Hou 2007-06-08 13:29:55 Re: the right time to vacuum database?

Browse pgsql-performance by date

  From Date Subject
Next Message Dan Harris 2007-06-08 14:29:24 Re: [ADMIN] reclaiming disk space after major updates
Previous Message Kristo Kaiv 2007-06-08 08:27:18 Re: VERY slow queries at random