Received: from maia.hub.org (unknown [200.46.208.211])
	by mail.postgresql.org (Postfix) with ESMTP id 643EC6325E3
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Sat, 20 Feb 2010 21:30:05 -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 20712-05
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Sun, 21 Feb 2010 01:29:47 +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 B9CC163161C
	for <pgsql-performance@postgresql.org>;
	Sat, 20 Feb 2010 21:29:54 -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 C280D678C5;
	Sat, 20 Feb 2010 18:29:52 -0700 (MST)
From: "George Sexton" <georges@mhsoftware.com>
To: "'Tom Lane'" <tgl@sss.pgh.pa.us>
Cc: <pgsql-performance@postgresql.org>
References: <053401cab291$a8cf7250$fa6e56f0$@com>
	<25691.1266714920@sss.pgh.pa.us>
In-Reply-To: <25691.1266714920@sss.pgh.pa.us>
Subject: Re: AutoVacuum_NapTime 
Date: Sat, 20 Feb 2010 18:29:51 -0700
Message-ID: <053801cab295$5df355e0$19da01a0$@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: Acqyk1k0AaqqEqiYQe6eHR0d8K/XBAAACPjQ
Content-Language: en-us
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/283
X-Sequence-Number: 37704

> -----Original Message-----
> From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
> Sent: Saturday, February 20, 2010 6:15 PM
> To: George Sexton
> Cc: pgsql-performance@postgresql.org
> Subject: Re: [PERFORM] AutoVacuum_NapTime
> 
> "George Sexton" <georges@mhsoftware.com> writes:
> > 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?
> 
> autovacuum_naptime is the cycle time for any one database, so you'd
> get an autovac worker launched every 60/330 seconds ...
> 
> 			regards, tom lane

Thanks. That's non-optimal for my usage. I'll change it.

Another question then. Say I set it to 720 minutes, which if I understand
things would see each db done twice per day.

If I'm cold starting the system, would it vacuum all 330 databases and then
wait 720 minutes and then do them all again, or would it distribute the
databases more or less evenly over the time period?

George Sexton
MH Software, Inc.
http://www.mhsoftware.com/
Voice: 303 438 9585