Drupal and PostgreSQL - performance issues? - Mailing list pgsql-general

From Mikkel Høgh
Subject Drupal and PostgreSQL - performance issues?
Date
Msg-id 2434A118-CEFA-43A9-BA88-006EC1F80326@hoegh.org
Whole thread Raw
Responses Re: Drupal and PostgreSQL - performance issues?  (John DeSoi <desoi@pgedit.com>)
Re: [PERFORM] Drupal and PostgreSQL - performance issues?  ("Scott Marlowe" <scott.marlowe@gmail.com>)
Re: [PERFORM] Drupal and PostgreSQL - performance issues?  (Stephen Frost <sfrost@snowman.net>)
Re: Drupal and PostgreSQL - performance issues?  ("Uwe C. Schroeder" <uwe@oss4u.com>)
Re: [PERFORM] Drupal and PostgreSQL - performance issues?  ("Ang Chin Han" <ang.chin.han@gmail.com>)
Re: Drupal and PostgreSQL - performance issues?  ("Daniel Verite" <daniel@manitou-mail.org>)
List pgsql-general
Hi there,

I've been toying with using PostgreSQL for some of my Drupal sites for
some time, and after his session at OpenSourceDays in Copenhagen last
weekend, Magnus Hagander told me that there a quite a few in the
PostgreSQL community using Drupal.

I have been testing it a bit performance-wise, and the numbers are
worrying. In my test, MySQL (using InnoDB) had a 40% lead in
performance, but I'm unsure whether this is indicative for PostgreSQL
performance in general or perhaps a misconfiguration on my part.

In any case, if anyone has any tips, input, etc. on how best to
configure PostgreSQL for Drupal, or can find a way to poke holes in my
analysis, I would love to hear your insights :)

The performance test results can be found on my blog:
http://mikkel.hoegh.org/blog/2008/drupal_database_performance_mysql_and_postgresql_compared
--
Kind regards,

Mikkel Høgh <mikkel@hoegh.org>


Attachment

pgsql-general by date:

Previous
From: "Rodrigo E. De León Plicet"
Date:
Subject: Re: Need schema design advice
Next
From: John DeSoi
Date:
Subject: Re: Drupal and PostgreSQL - performance issues?