Re: database contest results - Mailing list pgsql-advocacy

From Anastasios Hatzis
Subject Re: database contest results
Date
Msg-id 44F453BD.1080700@gmx.net
Whole thread Raw
In response to Re: database contest results  (Andreas Pflug <pgadmin@pse-consulting.de>)
List pgsql-advocacy
Andreas Pflug wrote:
> Hans-Juergen Schoenig wrote:
>
>> Lukas Kahwe Smith wrote:
>>
>>> Hi,
>>>
>>> I have not studied this contest in any detail. However the
>>> performance differences seem kind of unrealistic:
>>> http://www.mysql.com/news-and-events/press-release/release_2006_35.html
>>>
>> this is pure marketing.
>> i have seen postgres beat mysql in many many cases. same with oracle.
>> i assume that those tests are all done with ISAM. with ISAM everything
>> is fast but you cannot reboot the box without facing serious
>> corruption. in business applications stability is as least as
>> important as speed.
>>
> the prerequisites where quite mysql-drawn right from the start. The
> MySQL team did a very good job tuning the existent application to access
> the database as rare as possible using memcache, and dropped all
> constraints (no surprise...). Porting _that_ optimized app to pgsql
> would be really interesting and comparable.
>
Good Point :-)) Does it mean that a faster way working with mysql is by using mysql as little as possible? Probably
thanthe fastest way is  never using mysql? 

SCNR

Anastasios


pgsql-advocacy by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: 7.4 Development
Next
From: Robert Treat
Date:
Subject: Re: [pgsql-www] Getting better Google search