Tom Lane escribió: > =?UTF-8?B?xYF1a2FzeiBKYWdpZcWCxYJv?= <lukasz.jagie...@gforces.pl> writes: > > That autovacuum working hole time, shoudn't be run only when db needs ? > > With 2000 databases to cycle through, autovac is going to be spending > quite a lot of time just finding out whether it needs to do anything. > I believe the interpretation of autovacuum_naptime is that it should > examine each database that often, ie once a minute by default. So > it's got more than 30 databases per second to look through.
Note that this is correct in 8.1 and 8.2 but not 8.3 onwards. -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
