Received: from localhost (maia-1.hub.org [200.46.204.191])
	by postgresql.org (Postfix) with ESMTP id 1F3B29FB641;
	Thu, 25 Jan 2007 12:33:39 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.191]) (amavisd-new, port 10024)
	with ESMTP id 86772-08; Thu, 25 Jan 2007 12:33:29 -0400 (AST)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.4
X-Greylist: from auto-whitelisted by SQLgrey-1.7.4
Received: from locust.cns.vt.edu (locust.cns.vt.edu [198.82.169.14])
	by postgresql.org (Postfix) with ESMTP id 827479FB4DF;
	Thu, 25 Jan 2007 12:33:29 -0400 (AST)
Received: by locust.cns.vt.edu (Postfix, from userid 986)
	id 17989118A32; Thu, 25 Jan 2007 11:33:29 -0500 (EST)
Date: Thu, 25 Jan 2007 11:33:29 -0500
From: Ray Stell <stellr@cns.vt.edu>
To: "Joshua D. Drake" <jd@commandprompt.com>
Cc: "Jim C. Nasby" <jim@nasby.net>, Galy Lee <lee.galy@oss.ntt.co.jp>,
	pgsql-performance@postgresql.org, Hackers <pgsql-hackers@postgresql.org>
Subject: Re: [HACKERS] how to plan for vacuum?
Message-ID: <20070125163329.GD19599@cns.vt.edu>
References: <45B6F0A8.1050705@oss.ntt.co.jp>
 <20070125033917.GD64372@nasby.net>
	<20070125035202.GI26006@alvh.no-ip.org>
	<45B8D521.8010405@commandprompt.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <45B8D521.8010405@commandprompt.com>
User-Agent: Mutt/1.5.11
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200701/372
X-Sequence-Number: 22973

On Thu, Jan 25, 2007 at 08:04:49AM -0800, Joshua D. Drake wrote:
> 
> It really depends on the system. Most of our systems run anywhere from
> 10-25ms. I find that any more than that, Vacuum takes too long.


How do you measure the impact of setting it to 12 as opposed to 15?