[development] drupal on postgresql benchmark

[Bill Moran]

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.

*shrug*

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
http://www.potentialtech.com