From: Gregory Stark <stark@enterprisedb.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 12:49:26 +0000
Message-ID: <87k5nan92h.fsf@oxford.xeocode.com> (raw)
In-Reply-To: <476908BB.5090408@stuartbishop.net>
References: <476908BB.5090408@stuartbishop.net>
"Stuart Bishop" <stuart@stuartbishop.net> writes:
> 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).
There was a problem in the past which affected Xeons. But I thought it had
been mostly addressed. Xeons are (or were? these things are always changing)
more sensitive to interprocess contention due to their memory architecture
though.
What are you actually doing in these transactions? Are they read-only? If not
is fsync=off (which you don't want if you care about your data but you do if
you're trying to benchmark the cpu).
Are the crappy disks *identical* crappy disks? If they have different
controllers or different drives (or different versions of the OS) then you
might be being deceived by write caching on one set and not the other. If
they're not read-only transactions and fsync=on then the TPS of 3000+ is not
credible and this is likely.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
Ask me about EnterpriseDB's RemoteDBA services!
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: stark@enterprisedb.com, stuart@stuartbishop.net
Subject: Re: Dual core Opterons beating quad core Xeons?
In-Reply-To: <87k5nan92h.fsf@oxford.xeocode.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