Quoting Bill Moran <wmoran@potentialtech.com>:
I'm interested in improving the performance of Drupal, the performance of PostgreSQL, and the performance of Drupal running on PostgreSQL. I can help with that, but trying to tune Drupal queries when PostgreSQL isn't tuned for the hardware it's running on is a recipe for wasted time.
I'm not interested in proving that PostgreSQL is better than MySQL, I'm interested in _making_ PostgreSQL better than MySQL. To do that, I need data. Unfortunately, "PostgreSQL's default config performs poorly" isn't helpful data ;)
I've recently been playing with index modifications for improvement of the DB of MySql. I haven't gotten to the point of opening a ticket for all of the changes yet but I have at least one open. Earnie -- http://for-my-kids.com/ -- http://give-me-an-offer.com/