On Sat, Nov 10, 2012 at 2:12 PM, Jeff Janes <jeff.janes@xxxxxxxxx> wrote: > On Fri, Nov 9, 2012 at 5:56 PM, Scott Marlowe <scott.marlowe@xxxxxxxxx> wrote: >> >> As well, since the default nap time is 1 minute, it will take at least >> 50 minutes to vacuum each db as nap time is how long autovac waits >> between databases. > > That isn't how it works. The naptime is per database, not per > cluster. If the naptime is 1 minute and there are 50 "active" > databases, then it will launch a new worker every 1.2 seconds > (assuming the old ones finish fast enough that doing so would not > exceed autovacuum_max_workers) Hmmm. That was not my understanding from previous discussions on nap time. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
