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.
The OP is using 8.2 though so it doesn't apply here.
--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
