Re: PostgreSQL not ACID compliant? - Mailing list pgsql-hackers

From Joshua D. Drake
Subject Re: PostgreSQL not ACID compliant?
Date
Msg-id 3F6BA92D.6070800@commandprompt.com
Whole thread Raw
In response to Re: PostgreSQL not ACID compliant?  (Philip Yarra <philip@utiba.com>)
List pgsql-hackers
Hello,
 Actually if you really want to scare them.

1. Use Innodb
2. Create 5000 inserts with at least 5k of data. The table needs to have 
a primary key.
3. Insert the 5000 records for 50 connections (250,000 inserts).
4. Watch the deadlocks fly.
 They didn't believe me. Then the guy tried it live on #mysql... and it 
crashed. He blamed
it on the fact he only gave 8 meg to Innodb.

Sincerely,

Joshua Drake


Philip Yarra wrote:

>It's funny timing - I had to prepare a comparison between PostgreSQL and 
>MySQL recently, explaining why we would prefer PostgreSQL. I know some 
>people here have issues with the MySQL crashme test results, but I have to 
>say I found it possibly one of the best postgreSQL advertisements 
>available. A 4-way comparison between Sybase, Oracle, MySQL and PostgreSQL 
>shows PostgreSQL in an extremely flattering light.
>
>Given the missing features in MySQL (column constraints and views, for 
>god's sake!) I had to 
>conclude that we couldn't implement most of our projects in MySQL, even if 
>we wanted to. I have trouble believing MySQL was suggested as a viable 
>alternative.
>
>I know I'm preaching to the choir here, but thought you might find it of 
>interest.
>
>Regards, Philip Yarra.
>  
>

-- 
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-222-2783 - jd@commandprompt.com - http://www.commandprompt.com
The most reliable support for the most reliable Open Source database.




pgsql-hackers by date:

Previous
From: Philip Yarra
Date:
Subject: Re: PostgreSQL not ACID compliant?
Next
From: Christopher Browne
Date:
Subject: Re: PostgreSQL not ACID compliant?