X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 3BB0ED1B500 for ; Tue, 21 Oct 2003 20:55:34 +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 47580-07 for ; Tue, 21 Oct 2003 17:55:05 -0300 (ADT) Received: from mail.libertyrms.com (unknown [209.167.124.227]) by svr1.postgresql.org (Postfix) with ESMTP id E550BD1B4FD for ; Tue, 21 Oct 2003 17:55:02 -0300 (ADT) Received: from [10.1.2.130] (helo=dba2) by mail.libertyrms.com with esmtp (Exim 3.22 #3 (Debian)) id 1AC3Wy-0007p8-00 for ; Tue, 21 Oct 2003 16:55:04 -0400 Received: by dba2 (Postfix, from userid 1019) id DB80ACD6A; Tue, 21 Oct 2003 16:55:04 -0400 (EDT) Date: Tue, 21 Oct 2003 16:55:04 -0400 From: Andrew Sullivan To: pgsql-performance@postgresql.org Subject: Re: Tuning for mid-size server Message-ID: <20031021205504.GJ11421@libertyrms.info> Mail-Followup-To: Andrew Sullivan , pgsql-performance@postgresql.org References: <2F2E24372F10744588A27DEECC85FE04B6769D@vt-pe2550-001.vantage.vantage.com> <200310211015.57569.josh@agliodbs.com> <20031021175016.GH11421@libertyrms.info> <200310211151.02751.josh@agliodbs.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <200310211151.02751.josh@agliodbs.com> User-Agent: Mutt/1.5.4i X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200310/558 X-Sequence-Number: 4306 On Tue, Oct 21, 2003 at 11:51:02AM -0700, Josh Berkus wrote: > Of course, if you have anecdotal evidence to the contrary, then the > only way to work this would be to have OSDL help us sort it out. Nope. I too have such anecdotal evidence that 25% is way too high. It also seems to depend pretty heavily on what you're trying to optimise for and what platform you have. But I'm glad to hear (again) that people seem to think the 25% too high for most cases. I don't feel so much like I'm tilting against windmills. A -- ---- Andrew Sullivan 204-4141 Yonge Street Afilias Canada Toronto, Ontario Canada M2P 2A8 +1 416 646 3304 x110