From: | Greg Smith <gsmith(at)gregsmith(dot)com> |
---|---|
To: | Mikkel Høgh <mikkel(at)hoegh(dot)org> |
Cc: | pgsql-performance(at)postgresql(dot)org |
Subject: | Re: Drupal and PostgreSQL - performance issues? |
Date: | 2008-10-13 10:17:31 |
Message-ID: | Pine.GSO.4.64.0810130554140.3332@westnet.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-performance |
On Mon, 13 Oct 2008, Mikkel Hgh 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(at)gregsmith(dot)com http://www.gregsmith.com Baltimore, MD
From | Date | Subject | |
---|---|---|---|
Next Message | Vladimir Dzhuvinov | 2008-10-13 10:24:08 | Re: PL/pgSQL stored procedure returning multiple result sets (SELECTs)? |
Previous Message | arnuld uttre | 2008-10-13 10:17:01 | Re: user and DB confusion |
From | Date | Subject | |
---|---|---|---|
Next Message | Ang Chin Han | 2008-10-13 10:36:03 | Re: [PERFORM] Drupal and PostgreSQL - performance issues? |
Previous Message | Mikkel Høgh | 2008-10-13 08:51:30 | Re: Drupal and PostgreSQL - performance issues? |