[development] drupal on postgresql benchmark

[Khalid Baheyeldin]

On Nov 26, 2007 2:00 PM, Michael Favia <michael at favias.org> wrote:

> Bill Moran wrote:
> > In response to Gerhard Killesreiter <gerhard at killesreiter.de>:
> > 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.
> >
> I think this misses the point of the experiment which was to see which
> ran faster out of the box without optimization, not which can be made to
> run faster (which is another useful experiment but much more complicated
> loads, read/write/update ratio, transactions, etc).
>

Michael

You are right. This measures the out of the box experience.

Tuning a site is labor intensive, expensive and on going. What people get
out of the box is very important.


> On the other hand i completely agree with your points above and realize
> that those individuals most concerned with performance should have or
> desire the knowledge to properly configure the database engine/server.
> Unfortunately this isnt a black box many people like to touch readily.
>
> I'm all for making things go faster i just think this test wasn't meant
> to prove database superiority or anything like that and that is what
> this seems to have morphed into.


This is why my comment at the end of the article which Bill picked up. I
want people to share experiences on tuning PostgreSQL, so we can have a more
level playing field with more complex setups.

-- 
Khalid M. Baheyeldin
2bits.com
http://2bits.com
Drupal optimization, development, customization and consulting.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.drupal.org/pipermail/development/attachments/20071126/fc129fc0/attachment.htm