[development] drupal on postgresql benchmark

[David Norman]

Since these are Drupal-specific benchmarks, and Drupal doesn't utilize
any of the ACID type stuff (even though it would be nice in D7), I think
it is relevant to compare the out of the box configs like MyISAM.

Speaking of which, maybe adding ACID isn't that hard - keep track of
what is InnoDB and let the db include files send a START TRANSACTION
when it is possible (speaking in a frame of PHP5
__construct()/__destruct() perhaps).

matt at mattfarina.com wrote:
> Two Thoughts:
> 
> 1) MySQL 5.1 is supposed to be faster than MySQL 5.0.
> 
> 2) Isn't the more accurate feature comparison InnoDB to PostgreSQL.
> MyISAM is a more light weight engine. InnoDB is more comparable to
> PostgreSQL with regard to features. Row level locking and that kind of
> thing.
> 
> Matt
> 
> Quoting Khalid Baheyeldin <kb at 2bits.com>:
> 
>> Well, I did some benchmarks, and they show that, out of the box at least,
>> MySQL is faster.
>>
>> Here they are:
>>
>> http://2bits.com/articles/benchmarking-postgresql-vs-mysql-performance-using-drupal-5x.html
>>
>>
>> On Nov 25, 2007 1:24 PM, Ivan Sergio Borgonovo <mail at webthatworks.it>
>> wrote:
>>
>>> I just found this:
>>>
>>> Converted the site from MySQL to PostgreSQL
>>>
>>> http://jamonation.com/node/734
>>>
>>> it is not explicitly said but the site should run drupal.
>>>
>>> -- 
>>> Ivan Sergio Borgonovo
>>> http://www.webthatworks.it
>>>
>>>
>>
>>
>> -- 
>> Khalid M. Baheyeldin
>> 2bits.com
>> http://2bits.com
>> Drupal optimization, development, customization and consulting.
>>
> 
> 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/x-pkcs7-signature
Size: 3805 bytes
Desc: S/MIME Cryptographic Signature
Url : http://lists.drupal.org/pipermail/development/attachments/20071126/ae85cbe0/attachment.bin