Received: from localhost (unknown [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id B82472E2DBB for ; Wed, 19 Dec 2007 11:26:42 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 96429-08 for ; Wed, 19 Dec 2007 11:26:39 -0400 (AST) Received: from wr-out-0506.google.com (wr-out-0506.google.com [64.233.184.233]) by postgresql.org (Postfix) with ESMTP id A75B92E2DA7 for ; Wed, 19 Dec 2007 11:26:39 -0400 (AST) Received: by wr-out-0506.google.com with SMTP id 58so2353640wri.10 for ; Wed, 19 Dec 2007 07:26:38 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; bh=n7RWBTUivIXZWw6t2tAjOLQdSnoqmn42xUSXtOMJBCY=; b=lCmDcqP4S1Fqy0ARSVtOl0qHRlA/CStcTFitIUlcstFa9N4QcNRzArPT9s8EhNdvNTDhRToDDxkzH3+KQXuAb0St7n88ATFrO6d956GT6rNO7E/8ABgtfSfr71Ju1WyOvI3VQ7TzMdZANQ130V1VfmkIurnmxzAzl1XyCqvpdRw= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=ZwRLc4CMtFX8l77r1Sgsv2Mx3PW9hm5x3R14/G/wWndet1bnTITSB301eNM0UHNN+dyGmV3CeChjSRmkxwbIQXbntxLjU/LEt6Gj6qd5UEniPxW6g4SHDA6gwm/HpB/TmkKZjUvYVNALJgPCrYgAv2IgiX66BCraqchypNvpdPM= Received: by 10.142.216.9 with SMTP id o9mr400323wfg.226.1198077996081; Wed, 19 Dec 2007 07:26:36 -0800 (PST) Received: by 10.142.143.6 with HTTP; Wed, 19 Dec 2007 07:26:36 -0800 (PST) Message-ID: Date: Wed, 19 Dec 2007 09:26:36 -0600 From: "Scott Marlowe" To: "Stuart Bishop" Subject: Re: Dual core Opterons beating quad core Xeons? Cc: pgsql-performance@postgresql.org In-Reply-To: <476908BB.5090408@stuartbishop.net> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <476908BB.5090408@stuartbishop.net> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200712/280 X-Sequence-Number: 28096 On Dec 19, 2007 6:04 AM, Stuart Bishop wrote: > Hi. > > We are looking at upgrading our primary servers. The final boxes will have > 128GB ram, fast disk arrays and 4 CPUs. > > We currently have some eval units with 8GB ram and crappy disk to let us > benchmark CPU choice. One box has 4 3GHz dual core Opterons with 1MB cache, > the other box ha 4 3GHz quad core Xeons with 4MB cache. Imagine two scenarios. In one you have an infinite number of hard drives with an infinite amount of battery backed cache, and an infinite I/O bandwidth. In the other you have one disk. Which one is likely to be I/O bound? Yep. So, it's not likely you'll be able to do a realistic benchmark of the CPUs with such a limited disk subsystem... > For pgbench (PG 8.2 running Ubuntu), the Opteron is getting about 6x TPS > over the Xeon (3000+ TPS on Opteron vs ~500 on Xeon). Things get a little > better for Xeon with PG 8.3 (570-540 TPS). pgbench is a mostly I/O bound benchmark. What are your -c, -t and -s settings btw? It's would be much better if you could benchmark something like the real load you'll be running in the future. Are you looking at reporting, transactions, content management, etc...?