[development] drupal on postgresql benchmark
wmoran at potentialtech.com
Mon Nov 26 18:52:51 UTC 2007
In response to Gerhard Killesreiter <gerhard at killesreiter.de>:
> -----BEGIN PGP SIGNED MESSAGE-----
> 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.
More information about the development