Skip site navigation (1) Skip section navigation (2)

Re: Drupal and PostgreSQL - performance issues?

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 (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-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

In response to

pgsql-performance by date

Next:From: Ang Chin HanDate: 2008-10-13 10:36:03
Subject: Re: [PERFORM] Drupal and PostgreSQL - performance issues?
Previous:From: Mikkel HøghDate: 2008-10-13 08:51:30
Subject: Re: Drupal and PostgreSQL - performance issues?

pgsql-general by date

Next:From: Vladimir DzhuvinovDate: 2008-10-13 10:24:08
Subject: Re: PL/pgSQL stored procedure returning multiple result sets (SELECTs)?
Previous:From: arnuld uttreDate: 2008-10-13 10:17:01
Subject: Re: user and DB confusion

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group