<br><br><div class="gmail_quote">On Nov 26, 2007 2:00 PM, Michael Favia <<a href="mailto:michael@favias.org">michael@favias.org</a>> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div class="Ih2E3d">Bill Moran wrote:<br>> In response to Gerhard Killesreiter <<a href="mailto:gerhard@killesreiter.de">gerhard@killesreiter.de</a>>:<br></div><div class="Ih2E3d">> My point is:<br>> a) Let me send you a tweaked
postgresql.conf file and well find<br>> out whether the performance difference is simply a matter of<br>> untuned configuration and ...<br>> b) Let me have the query log after the test and I'll see if I
<br>> can identify any queries that could be improved, then someone<br>> else can test to see if the improved queries are acceptable<br>> from the MySQL standpoint.<br>><br></div>I think this misses the point of the experiment which was to see which
<br>ran faster out of the box without optimization, not which can be made to<br>run faster (which is another useful experiment but much more complicated<br>loads, read/write/update ratio, transactions, etc).<br></blockquote>
<div><br>Michael<br><br>You are right. This measures the out of the box experience.<br><br>Tuning a site is labor intensive, expensive and on going. What people get out of the box is very important.<br><br></div><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<br>On the other hand i completely agree with your points above and realize<br>that those individuals most concerned with performance should have or<br>desire the knowledge to properly configure the database engine/server.
<br>Unfortunately this isnt a black box many people like to touch readily.<br><br>I'm all for making things go faster i just think this test wasn't meant<br>to prove database superiority or anything like that and that is what
<br>this seems to have morphed into.</blockquote><div><br>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.
<br><br></div></div>-- <br>Khalid M. Baheyeldin<br><a href="http://2bits.com">2bits.com</a><br><a href="http://2bits.com">http://2bits.com</a><br>Drupal optimization, development, customization and consulting.