X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 75A68DB12C for ; Thu, 10 Nov 2005 11:24:44 -0400 (AST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 41811-08 for ; Thu, 10 Nov 2005 15:24:40 +0000 (GMT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from frank.wiles.org (frank.wiles.org [24.124.39.75]) by svr1.postgresql.org (Postfix) with ESMTP id 72D33DB0E7 for ; Thu, 10 Nov 2005 11:24:42 -0400 (AST) Received: from kungfu (frank.wiles.org [127.0.0.1]) by frank.wiles.org (8.13.1/8.13.1) with SMTP id jAAFOhXR009054; Thu, 10 Nov 2005 09:24:44 -0600 Date: Thu, 10 Nov 2005 09:25:01 -0600 From: Frank Wiles To: Scott Marlowe Cc: pgsql-performance@postgresql.org Subject: Re: Some help on buffers and other performance tricks Message-Id: <20051110092501.36663aa4.frank@wiles.org> In-Reply-To: <1131635770.3554.58.camel@state.g2switchworks.com> References: <1793468.1131596410309.JavaMail.root@elwamui-hound.atl.sa.earthlink.net> <1131635770.3554.58.camel@state.g2switchworks.com> X-Mailer: Sylpheed version 2.0.1 (GTK+ 2.6.10; i686-pc-linux-gnu) Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.015 required=5 tests=[AWL=0.015] X-Spam-Score: 0.015 X-Spam-Level: X-Archive-Number: 200511/177 X-Sequence-Number: 15434 On Thu, 10 Nov 2005 09:16:10 -0600 Scott Marlowe wrote: > Very valid point. It's the reason, in my last job, we had a mainline > server with dual 2800MHz CPUs and a big RAID array. > > And our development, build and test system was a Dual Pentium Pro 200 > with 256 Meg of ram. You notice slow queries real fast on such a box. I know several people who use this development method. It can sometimes lead to premature optimizations, but overall I think it is a great way to work. --------------------------------- Frank Wiles http://www.wiles.org ---------------------------------