Re: Re: dramatic slowdown. . .fixed by vacuum

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@cat-it.co.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