[development] drupal on postgresql benchmark

Bill Moran wmoran at potentialtech.com
Mon Nov 26 18:52:51 UTC 2007

In response to Gerhard Killesreiter <gerhard at killesreiter.de>:

> Hash: SHA1
> Bill Moran schrieb:
> > (MySQL, for example is
> > faster at executing simply SELECT queries than anything else
> > out there, whereas PostgreSQL is faster at complex joins ...
> > if Drupal fetches related data from 5 tables in five separate
> > SELECTS instead of 1 big SELECT with a bunch of joins, then it
> > will always be faster on MySQL).
> Drupal usually goes for joins rather than multiple single selects.


My point is:
a) Let me send you a tweaked postgresql.conf file and well find
   out whether the performance difference is simply a matter of
   untuned configuration and ...
b) Let me have the query log after the test and I'll see if I
   can identify any queries that could be improved, then someone
   else can test to see if the improved queries are acceptable
   from the MySQL standpoint.

Bill Moran

More information about the development mailing list