X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 894E6D1DC04 for ; Sun, 14 Dec 2003 17:56:29 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 28518-06 for ; Sun, 14 Dec 2003 13:56:00 -0400 (AST) Received: from mail.libertyrms.com (unknown [209.167.124.227]) by svr1.postgresql.org (Postfix) with ESMTP id 01D27D1DB9D for ; Sun, 14 Dec 2003 13:56:00 -0400 (AST) Received: from [10.1.2.146] (helo=dba3.int.libertyrms.info) by mail.libertyrms.com with esmtp (Exim 3.22 #3 (Debian)) id 1AVaT6-0003PR-00; Sun, 14 Dec 2003 12:55:48 -0500 Received: by dba3.int.libertyrms.info (Postfix, from userid 1019) id 49F4C138CA; Sun, 14 Dec 2003 12:55:48 -0500 (EST) Date: Sun, 14 Dec 2003 12:55:48 -0500 From: Andrew Sullivan To: Bruce Momjian Cc: pgsql-performance@postgresql.org Subject: Re: Tuning for mid-size server Message-ID: <20031214175548.GA9375@libertyrms.info> Mail-Followup-To: Andrew Sullivan , Bruce Momjian , pgsql-performance@postgresql.org References: <20031021213408.GA12200@libertyrms.info> <200312140542.hBE5gLI21410@candle.pha.pa.us> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <200312140542.hBE5gLI21410@candle.pha.pa.us> User-Agent: Mutt/1.5.4i X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200312/220 X-Sequence-Number: 5080 On Sun, Dec 14, 2003 at 12:42:21AM -0500, Bruce Momjian wrote: > > I know this is an old email, but have you tested larger shared buffers > in CVS HEAD with Jan's new cache replacement policy? Not yet. It's on our TODO list, for sure, because the consequences of relying too much on the filesystem buffers under certain perverse loads is lousy database performance _precisely_ when we need it. I expect some testing of this type some time in January. A -- ---- Andrew Sullivan 204-4141 Yonge Street Afilias Canada Toronto, Ontario Canada M2P 2A8 +1 416 646 3304 x110