Re: Vaccuum best practice: cronjob or autovaccuum? - Mailing list pgsql-general

From Bill Moran
Subject Re: Vaccuum best practice: cronjob or autovaccuum?
Date
Msg-id 20080828120436.555bd3c2.wmoran@collaborativefusion.com
Whole thread Raw
In response to Re: Vaccuum best practice: cronjob or autovaccuum?  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-general
In response to Alvaro Herrera <alvherre@commandprompt.com>:

> For the record:
>
> Bill Moran escribió:
>
> > The naptime at 600 is probably a bad idea.  If you only have one user
> > database on this system, then it only gets investigated by autovac once
> > every 40 minutes (template0 ... template1 ... postgres ... yourdb)
> > Consider that autovac uses very little resources when it determines that
> > it has no work to do.
>
> Note that on 8.3, the meaning of naptime has changed -- it would be
> effectively "check each database once every 10 minutes" if set at 600.
> This was changed precisely because the previous semantics were difficult
> to explain/use.

Ooo ... that's an exciting "gotcha"!

--
Bill Moran
Collaborative Fusion Inc.
http://people.collaborativefusion.com/~wmoran/

wmoran@collaborativefusion.com
Phone: 412-422-3463x4023

pgsql-general by date:

Previous
From: Alan Hodgson
Date:
Subject: Re: Partitioned Tables - How/Can does slony handle it?
Next
From: Tom Lane
Date:
Subject: Re: pg_dump problem