| 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: | Whole Thread | Raw Message | 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
| 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? |
| 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 |