From: Cédric Villemain <cedric.villemain@dalibo.com>
To: Stuart Bishop <stuart@stuartbishop.net>
Cc: pgsql-performance@postgresql.org
Subject: Re: Dual core Opterons beating quad core Xeons?
Date: Wed, 19 Dec 2007 13:41:56 +0100
Message-ID: <47691194.20102@dalibo.com> (raw)
In-Reply-To: <476908BB.5090408@stuartbishop.net>
References: <476908BB.5090408@stuartbishop.net>
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.orgAttachments:cedric.villemain.vcf (text/x-vcard, 278B) download
begin:vcard
fn;quoted-printable:C=C3=A9dric Villemain
n;quoted-printable:Villemain;C=C3=A9dric
org:Dalibo
email;internet:cedric.villemain@dalibo.com
title:Consultant PostgreSQL
tel;cell:+33 (0)6 74 15 56 53
x-mozilla-html:FALSE
url:dalibo.com
version:2.1
end:vcard
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: cedric.villemain@dalibo.com, stuart@stuartbishop.net
Subject: Re: Dual core Opterons beating quad core Xeons?
In-Reply-To: <47691194.20102@dalibo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox