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 6C8D5DA16E for ; Wed, 5 Oct 2005 14:08:42 -0300 (ADT) 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 00854-02 for ; Wed, 5 Oct 2005 17:08:37 +0000 (GMT) Received: from pop-satin.atl.sa.earthlink.net (pop-satin.atl.sa.earthlink.net [207.69.195.63]) by svr1.postgresql.org (Postfix) with ESMTP id 3FE2FD6F47 for ; Wed, 5 Oct 2005 14:08:37 -0300 (ADT) Received: from elwamui-chisos.atl.sa.earthlink.net ([209.86.224.31]) by pop-satin.atl.sa.earthlink.net with esmtp (Exim 3.36 #10) id 1ENCkt-0002WZ-00; Wed, 05 Oct 2005 13:08:35 -0400 Message-ID: <25743727.1128532115286.JavaMail.root@elwamui-chisos.atl.sa.earthlink.net> Date: Wed, 5 Oct 2005 13:08:35 -0400 (EDT) From: Ron Peacetree Reply-To: Ron Peacetree To: Kevin Grittner , pgsql-performance@postgresql.org Subject: Re: Is There Any Way .... Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Mailer: EarthLink Zoo Mail 1.0 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.258 required=5 tests=[AWL=-0.116, DNS_FROM_RFC_ABUSE=0.374] X-Spam-Level: X-Archive-Number: 200510/107 X-Sequence-Number: 14875 From: Kevin Grittner Sent: Oct 5, 2005 2:16 AM Subject: Re: [PERFORM] Is There Any Way .... >First off, Mr. Trainor's response proves nothing about anyone or >anything except Mr. Trainor. > Fair Enough. I apologize for the inappropriately general statement. >I'm going to offer an opinion on the caching topic. I don't have >any benchmarks; I'm offering a general sense of the issue based on >decades of experience, so I'll give a short summary of that. > >I've been earning my living by working with computers since 1972, > ~1978 for me. So to many on this list, I also would be an "old fart". > I've pretty much spent my entire career thinking about and making advances in RW distributed computing and parallel processing as first a programmer and then a systems architect. >Now on to the meat of it. > I agree with your comments just about across the board. I also agree with the poster(s) who noted that the "TLC factor" and the 2x every 18months pace of increasing HW performance and RAM capacity make this stuff a moving target. OTOH, there are some fundamentals that don't seem to change no matter how far or fast the computing field evolves. As usual, the proper answers involve finding a sometimes nontrivial balance between building on known precedent and not being trapped by doctrine. Ron