Received: from maia.hub.org (unknown [200.46.208.211])
	by mail.postgresql.org (Postfix) with ESMTP id 14B156325E3
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Sat, 20 Feb 2010 21:03:33 -0400 (AST)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.208.211]) (amavisd-maia,
	port 10024) with ESMTP id 16137-05
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Sun, 21 Feb 2010 01:03:15 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from mail.mhsoftware.com (mail.mhsoftware.com [209.169.14.178])
	by mail.postgresql.org (Postfix) with ESMTP id 8508A632593
	for <pgsql-performance@postgresql.org>;
	Sat, 20 Feb 2010 21:03:22 -0400 (AST)
Received: from emp00 (c-76-120-104-193.hsd1.co.comcast.net [76.120.104.193])
	(using TLSv1 with cipher RC4-MD5 (128/128 bits))
	(No client certificate requested)
	by mail.mhsoftware.com (Postfix) with ESMTPSA id 76377678C5
	for <pgsql-performance@postgresql.org>;
	Sat, 20 Feb 2010 18:03:20 -0700 (MST)
From: "George Sexton" <georges@mhsoftware.com>
To: <pgsql-performance@postgresql.org>
Subject: AutoVacuum_NapTime
Date: Sat, 20 Feb 2010 18:03:19 -0700
Message-ID: <053401cab291$a8cf7250$fa6e56f0$@com>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit
X-Mailer: Microsoft Office Outlook 12.0
Thread-Index: AcqyjxP91nusE88NRaSNGidQJKMVqA==
Content-Language: en-us
x-cr-hashedpuzzle: AYNU AZoj Aay/ A7Gy CFK5 D7nM E8yR FFH7 FMAo FjSY F+w3 HQAG
	HR+F HUhJ IzZJ I3Kh; 1;
	cABnAHMAcQBsAC0AcABlAHIAZgBvAHIAbQBhAG4AYwBlAEAAcABvAHMAdABnAHIAZQBzAHEAbAAuAG8AcgBnAA==;
	Sosha1_v1; 7; {1C28DA26-8476-48A2-A49C-070C4D24E1F7};
	ZwBlAG8AcgBnAGUAcwBAAG0AaABzAG8AZgB0AHcAYQByAGUALgBjAG8AbQA=;
	Sun, 21 Feb 2010 01:03:13 GMT;
	QQB1AHQAbwBWAGEAYwB1AHUAbQBfAE4AYQBwAFQAaQBtAGUA
x-cr-puzzleid: {1C28DA26-8476-48A2-A49C-070C4D24E1F7}
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-2.599 tagged_above=-10 required=5
	tests=BAYES_00=-2.599
X-Spam-Level: 
X-Archive-Number: 201002/281
X-Sequence-Number: 37702

I have a system with around 330 databases running PostgreSQL 8.4.2

What would the expected behavior be with AutoVacuum_NapTime set to the
default of 1m and autovacuum_workers set to 3?

What I'm observing is that the system is continuously vacuuming databases.
Would these settings mean the autovacuum worker would try to vacuum all 330
databases once per minute?

George Sexton