From: | Andrew McMillan <Andrew(at)catalyst(dot)net(dot)nz> |
---|---|
To: | Joe Slag <jslag(at)visi(dot)com> |
Cc: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: Re: dramatic slowdown. . .fixed by vacuum |
Date: | 2000-07-21 21:35:47 |
Message-ID: | 3978C233.FB8D8DFC@catalyst.net.nz |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Joe Slag wrote:
>
> I see in the docs the suggestion:
>
> We recommend that active production databases be VACUUMM-ed nightly
>
> Is this how people tend to do their vacuuming? Does anyone do programmatic
> vacuums instead of / in addition to a nightly run? Is vacuuming mainly
> necessary after big deletes, or are there other common situations
> requiring it?
I run vacuum more often than daily on a few tables which have frequent
updates and where I can handle the table lock for the necessary length
of time.
Cheers,
Andrew
--
_____________________________________________________________________
Andrew McMillan, e-mail: Andrew(at)cat-it(dot)co(dot)nz
Catalyst IT Ltd, PO Box 10-225, Level 22, 105 The Terrace, Wellington
Me: +64 (21) 635 694, Fax: +64 (4) 499 5596, Office: +64 (4) 499 2267
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2000-07-21 22:05:59 | Re: [NOVICE] pg_dump problem |
Previous Message | The Hermit Hacker | 2000-07-21 20:20:23 | Re: Re: dramatic slowdown. . .fixed by vacuum |