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 DD6EFD8FC5 for ; Thu, 10 Nov 2005 11:16:09 -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 36868-08 for ; Thu, 10 Nov 2005 15:16:04 +0000 (GMT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from koolancexeon.g2switchworks.com (mail.g2switchworks.com [63.87.162.25]) by svr1.postgresql.org (Postfix) with ESMTP id 2A99ED7BB0 for ; Thu, 10 Nov 2005 11:16:06 -0400 (AST) Received: mail.g2switchworks.com 10.10.1.8 from 10.10.1.37 10.10.1.37 via HTTP with MS-WebStorage 6.5.6944 Received: from state.g2switchworks.com by mail.g2switchworks.com; 10 Nov 2005 09:16:10 -0600 Subject: Re: Some help on buffers and other performance tricks From: Scott Marlowe To: Ron Peacetree Cc: Frank Wiles , pgsql-performance@postgresql.org In-Reply-To: <1793468.1131596410309.JavaMail.root@elwamui-hound.atl.sa.earthlink.net> References: <1793468.1131596410309.JavaMail.root@elwamui-hound.atl.sa.earthlink.net> Content-Type: text/plain Content-Transfer-Encoding: 7bit Message-Id: <1131635770.3554.58.camel@state.g2switchworks.com> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.6 (1.4.6-2) Date: Thu, 10 Nov 2005 09:16:10 -0600 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.007 required=5 tests=[AWL=0.006, UNPARSEABLE_RELAY=0.001] X-Spam-Score: 0.007 X-Spam-Level: X-Archive-Number: 200511/176 X-Sequence-Number: 15433 On Wed, 2005-11-09 at 22:20, Ron Peacetree wrote: > The point Gentlemen, was that Good Architecture is King. That's what I was trying to emphasize by calling proper DB architecture step 0. All other things being equal (and they usually aren't, this sort of stuff is _very_ context dependent), the more of your critical schema that you can fit into RAM during normal operation the better. > > ...and it all starts with proper DB design. Otherwise, you are quite right in stating that you risk wasting time, effort, and HW. 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.