From: Greg Smith <gsmith@gregsmith.com>
To: Mikkel Høgh <mikkel@hoegh.org>
Cc: pgsql-performance@postgresql.org
Subject: Re: Drupal and PostgreSQL - performance issues?
Date: Mon, 13 Oct 2008 06:17:31 -0400 (EDT)
Message-ID: <Pine.GSO.4.64.0810130554140.3332@westnet.com> (raw)
In-Reply-To: <BEF0B6B6-8EAB-4082-B81C-819FA0982C0B@hoegh.org>
References: <2434A118-CEFA-43A9-BA88-006EC1F80326@hoegh.org>
<dcc563d10810122148r50dbfa6cy29972b65d66b0f6e@mail.gmail.com>
<Pine.GSO.4.64.0810130430450.3332@westnet.com>
<BEF0B6B6-8EAB-4082-B81C-819FA0982C0B@hoegh.org>
On Mon, 13 Oct 2008, Mikkel Høgh wrote:
> Well, in that benchmark, what you say is only true for the Niagara
> processors. On the Opteron page, MySQL performance only drops slightly as
> concurrency passes 50.
That's partly because the upper limit on the graph only goes to 100
concurrent processes. Since the Opterons are faster, that's not a broad
enough scale to see how fast the right edge of the MySQL curve falls.
You are right that the Niagara processors have a sharper decline than the
more traditional platforms. The MySQL 5.0.20a graphs at
http://tweakers.net/reviews/657/6 has a nice comparison graph showing a
few different architectures that's also interesting.
Anyway, you don't actually have to believe any of this; you've got a
testbed to try for yourself if you just crank the user count up. The main
thing I was trying to suggest is that MySQL being a bit faster at 5 users
is not unusual, but it's not really representative of which performs
better either.
> In general, MySQL seems to have problems with some kinds of threading,
> since their perfomance on Mac OS X is crappy as well for that reason.
One of the reasons (but by no means not the only one) that PostgreSQL uses
a multi-process based architecture instead of a threaded one is because
thread library quality varies so much between platforms.
--
* Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD
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: gsmith@gregsmith.com, mikkel@hoegh.org
Subject: Re: Drupal and PostgreSQL - performance issues?
In-Reply-To: <Pine.GSO.4.64.0810130554140.3332@westnet.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