In response to Alvaro Herrera <[EMAIL PROTECTED]>: > 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/ [EMAIL PROTECTED] Phone: 412-422-3463x4023 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
