X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 0A68E11F6228 for ; Wed, 26 Apr 2006 19:09:53 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 37289-01 for ; Wed, 26 Apr 2006 19:09:33 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from noel.decibel.org (noel.decibel.org [67.100.216.10]) by postgresql.org (Postfix) with ESMTP id B381711F6236 for ; Wed, 26 Apr 2006 19:09:30 -0300 (ADT) Received: by noel.decibel.org (Postfix, from userid 1001) id 292FE56435; Wed, 26 Apr 2006 17:09:30 -0500 (CDT) Received: (hashcash-sendmail, from uid 1001); Wed, 26 Apr 2006 17:09:29 -0500 Date: Wed, 26 Apr 2006 17:09:29 -0500 From: "Jim C. Nasby" To: Scott Marlowe Cc: mark@mark.mielke.cc, Bill Moran , pgsql-performance@postgresql.org Subject: Re: Large (8M) cache vs. dual-core CPUs Message-ID: <20060426220929.GY97354@pervasive.com> References: <20060425141435.6c8c163c.wmoran@collaborativefusion.com> <1145990018.23538.234.camel@state.g2switchworks.com> <20060425183817.GA9241@mark.mielke.cc> <1145990551.23538.244.camel@state.g2switchworks.com> <20060426005440.GA12711@mark.mielke.cc> <20060426011701.GB12711@mark.mielke.cc> <1146065238.23538.261.camel@state.g2switchworks.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <1146065238.23538.261.camel@state.g2switchworks.com> X-Operating-System: FreeBSD 6.0-RELEASE-p4 amd64 X-Distributed: Join the Effort! http://www.distributed.net User-Agent: Mutt/1.5.11 X-Hashcash: 1:20:060426:smarlowe@g2switchworks.com::pvYov70doGXUKNSt:00000000000 0000000000000000000000002MeT X-Hashcash: 1:20:060426:mark@mark.mielke.cc::NRshrpW+exZWS8Gj:000000000000000000 0000000000000000000000000hCm X-Hashcash: 1:20:060426:wmoran@collaborativefusion.com::AGYfdiuGXALmNtfs:0000000 0000000000000000000000000krR X-Hashcash: 1:20:060426:pgsql-performance@postgresql.org::a0fOKHjlIy0eXAV3:00000 0000000000000000000000002ia8 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200604/610 X-Sequence-Number: 18694 On Wed, Apr 26, 2006 at 10:27:18AM -0500, Scott Marlowe wrote: > If you haven't actually run a heavy benchmark of postgresql on the two > architectures, please don't make your decision based on other > benchmarks. Since you've got both a D920 and an X2 3800, that'd be a > great place to start. Mock up some benchmark with a couple dozen > threads hitting the server at once and see if the Intel can keep up. It Or better yet, use dbt* or even pgbench so others can reproduce... -- Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461