Re: Drupal and PostgreSQL - performance issues?

From: Mikkel Høgh <mikkel(at)hoegh(dot)org>
To: Martin Gainty <mgainty(at)hotmail(dot)com>
Cc: Ang Chin Han <ang(dot)chin(dot)han(at)gmail(dot)com>, Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>, Ivan Sergio Borgonovo <mail(at)webthatworks(dot)it>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: Drupal and PostgreSQL - performance issues?
Date: 2008-10-14 14:20:39
Message-ID: D62F9FEB-CC9F-4AA5-9301-34B6FB6977BF@hoegh.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-performance

On 14/10/2008, at 16.05, Martin Gainty wrote:
> > The benchmark is a mostly read-only Drupal site -- a few admins,
> but a
> > lot of readers. Drupal as a benchmark is skewed towards lots and
> lots
> > of small, simple queries, which MyISAM excels at. The long term fix
> > ought to be to help the Drupal team to make it
> MG>What about INNODB is Drupal forgetting the default engine for 5.x?

Well, my benchmark was actually running on InnoDB. With MyISAM, the
difference would probably have been even larger, but a lot less fair,
since MyISAM doesn't to any kind of integrity checks at all.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ivan Sergio Borgonovo 2008-10-14 14:28:22 Re: Drupal and PostgreSQL - performance issues?
Previous Message Scott Marlowe 2008-10-14 14:20:02 Re: Drupal and PostgreSQL - performance issues?

Browse pgsql-performance by date

  From Date Subject
Next Message Ivan Sergio Borgonovo 2008-10-14 14:28:22 Re: Drupal and PostgreSQL - performance issues?
Previous Message Scott Marlowe 2008-10-14 14:20:02 Re: Drupal and PostgreSQL - performance issues?