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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
