DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=message-id:date:from:user-agent:mime-version:to:subject:x-enigmail-version:content-type:sender;
	b=LHZFKgMFFu23lLHNqv00HzA127WvfWyJjOMJCJRy8NO6o4ztHFFCCqveZLgYGrsIU5JGgyfapvokM7/Tjnit1eYh05kaA2oRCDZgaAolMvty5Iya2+F52yVncfavUEx3+8yB8KZmyIG5YugmYjCK/nh79/ioPDwsPgWLGs/1ghQ=
Message-ID: <476908BB.5090408@stuartbishop.net>
Date: Wed, 19 Dec 2007 19:04:11 +0700
From: Stuart Bishop <stuart@stuartbishop.net>
User-Agent: Thunderbird 2.0.0.6 (X11/20071022)
MIME-Version: 1.0
To: pgsql-performance@postgresql.org
Subject: Dual core Opterons beating quad core Xeons?
Content-Type: multipart/signed; micalg=pgp-sha1;
	protocol="application/pgp-signature";
	boundary="------------enig8AEB89F43A8ED6000CD3D880"

This is an OpenPGP/MIME signed message (RFC 2440 and 3156)
--------------enig8AEB89F43A8ED6000CD3D880
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

Hi.

We are looking at upgrading our primary servers. The final boxes will hav=
e
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 cach=
e,
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 sysadmin=
s
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 screwe=
d
our benchmarks somehow?

Is this a PG specific win for Opteron, or will we see similar results wit=
h
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 aw=
are
of anything that might change the landscape for 8.4?

--=20
Stuart Bishop <stuart@stuartbishop.net>
http://www.stuartbishop.net/


--------------enig8AEB89F43A8ED6000CD3D880
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: OpenPGP digital signature
Content-Disposition: attachment; filename="signature.asc"

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFHaQi8AfqZj7rGN0oRArQXAJ9WIMgoE837pLYC6gHv4cmepIomwACdFc1c
lCnQoakaixRenvLvFbhWlus=
=eDwV
-----END PGP SIGNATURE-----

--------------enig8AEB89F43A8ED6000CD3D880--