Drupal and PostgreSQL - performance issues?

Поиск
Список
Период
Сортировка
От Mikkel Høgh
Тема Drupal and PostgreSQL - performance issues?
Дата
Msg-id 2434A118-CEFA-43A9-BA88-006EC1F80326@hoegh.org
обсуждение исходный текст
Ответы 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>)
Список 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>


Вложения

В списке pgsql-general по дате отправления:

Предыдущее
От: "Rodrigo E. De León Plicet"
Дата:
Сообщение: Re: Need schema design advice
Следующее
От: John DeSoi
Дата:
Сообщение: Re: Drupal and PostgreSQL - performance issues?