On Tue, 5 Aug 2003, Shridhar Daithankar wrote:

> On 5 Aug 2003 at 8:09, Jeff wrote:
> I would suggest autovacuum daemon which is in CVS contrib  works for 7.3.x as 
> well.. Or schedule a vacuum analyze every 15 minutes or so..

        I've just got autovacum up and Since we have had a lot of talk 
about it recently..... I thought some feed back might be useful.
        It seams to work quite well. But can be rather zelous on its 
analysing for the first few hours. Curretly its analysig static (ie 
nothigs changed) tables every 10minites. Vacuums seam to be about right.
        I think that many vacuums may be slowing does my database....

Peter Childs

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Reply via email to