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