From: Guido Neitzer <guido.neitzer@gmail.com>
To: Dave Cramer <pg@fastcrypt.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Opteron vs. Xeon "benchmark"
Date: Sat, 23 Sep 2006 15:49:53 +0200
Message-ID: <fbbe50e0609230649y2ca1cce4pc7a9b35540db95cd@mail.gmail.com> (raw)
In-Reply-To: <0ECF3B27-A4B2-46DA-A5C6-551BADB8F2ED@fastcrypt.com>
References: <ef06sk$1qb4$1@news.hub.org>
<4513A59E.3000807@valuecare.nl>
<C4228358-3848-4FA9-B194-CA114A561774@khera.org>
<45145AB7.70004@tweakers.net>
<20060922223617.GA22923@mark.mielke.cc>
<fbbe50e0609230600q1c9750a8nd45eeefc5f786e4f@mail.gmail.com>
<0ECF3B27-A4B2-46DA-A5C6-551BADB8F2ED@fastcrypt.com>
On 9/23/06, Dave Cramer <pg@fastcrypt.com> wrote:
> 1) The database fits entirely in memory, so this is really only
> testing CPU, not I/O which should be taken into account IMO
I don't think this really is a reason that MySQL broke down on ten or
more concurrent connections. The RAM might be, but I don't think so
too in this case as it represents exactly what we have seen in similar
tests. MySQL performs quite well on easy queries and not so much
concurrency. We don't have that case very often in my company ... we
have at least ten to twenty connections to the db performing
statements. And we have some fairly complex statements running very
often.
Nevertheless - a benchmark is a benchmark. Nothing else. We prefer
PostgreSQL for other reasons then higher performance (which it has for
lots of situations).
cug
--
PostgreSQL Bootcamp, Big Nerd Ranch Europe, Nov 2006
http://www.bignerdranch.com/news/2006-08-21.shtml
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: guido.neitzer@gmail.com, pg@fastcrypt.com
Subject: Re: Opteron vs. Xeon "benchmark"
In-Reply-To: <fbbe50e0609230649y2ca1cce4pc7a9b35540db95cd@mail.gmail.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