Message-ID: <47691194.20102@dalibo.com>
Date: Wed, 19 Dec 2007 13:41:56 +0100
From: =?UTF-8?B?Q8OpZHJpYyBWaWxsZW1haW4=?= <cedric.villemain@dalibo.com>
Organization: Dalibo
User-Agent: Mozilla-Thunderbird 2.0.0.6 (X11/20071009)
MIME-Version: 1.0
To: Stuart Bishop <stuart@stuartbishop.net>
CC: pgsql-performance@postgresql.org
Subject: Re: Dual core Opterons beating quad core Xeons?
References: <476908BB.5090408@stuartbishop.net>
In-Reply-To: <476908BB.5090408@stuartbishop.net>
Content-Type: multipart/mixed; boundary="------------060001060709070308070707"

This is a multi-part message in MIME format.
--------------060001060709070308070707
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit

Stuart Bishop a écrit :
> 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.
>
> model name      : Intel(R) Xeon(R) CPU           X7350  @ 2.93GHz
> cache size      : 4096 KB
> model name      : Dual-Core AMD Opteron(tm) Processor 8222 SE
> cache size      : 1024 KB
>
> I haven't had a chance to play with the hardware myself yet. The sysadmins
> have been running some benchmarks themselves though.
>
> For every non PG related benchmark they have run, the Xeon wins by around 20%.
>
> 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).
>
> Does this match what other people are seeing or expect, or have we screwed
> our benchmarks somehow?
>   
http://tweakers.net/reviews/661/7

as an example

You can travel the website for other benchs... (there are about  dual 
and quad core)

> Is this a PG specific win for Opteron, or will we see similar results with
> other DBs?
>
> Do people see wins for non-PG databases on Xeon, and are they as dramatic as
> we are seeing for PG on Opteron?
>
> With PG 8.2 and 8.3, is it still pretty much limited to 8 cores making 2 of
> the quad core Xeons redundant or detrimental?
>
> I expect we will be running this hardware for 8.2, 8.3 and 8.4. Anyone aware
> of anything that might change the landscape for 8.4?
>
>   


-- 
Cédric Villemain
Administrateur de Base de Données
Cel: +33 (0)6 74 15 56 53
http://dalibo.com - http://dalibo.org


--------------060001060709070308070707
Content-Type: text/x-vcard; charset=utf-8;
 name="cedric.villemain.vcf"
Content-Transfer-Encoding: base64
Content-Disposition: attachment;
 filename="cedric.villemain.vcf"

YmVnaW46dmNhcmQNCmZuO3F1b3RlZC1wcmludGFibGU6Qz1DMz1BOWRyaWMgVmlsbGVtYWlu
DQpuO3F1b3RlZC1wcmludGFibGU6VmlsbGVtYWluO0M9QzM9QTlkcmljDQpvcmc6RGFsaWJv
DQplbWFpbDtpbnRlcm5ldDpjZWRyaWMudmlsbGVtYWluQGRhbGliby5jb20NCnRpdGxlOkNv
bnN1bHRhbnQgUG9zdGdyZVNRTA0KdGVsO2NlbGw6KzMzICgwKTYgNzQgMTUgNTYgNTMNCngt
bW96aWxsYS1odG1sOkZBTFNFDQp1cmw6ZGFsaWJvLmNvbQ0KdmVyc2lvbjoyLjENCmVuZDp2
Y2FyZA0KDQo=
--------------060001060709070308070707--