Re: PostgreSQL vs. MySQL: fight - Mailing list pgsql-advocacy

From Decibel!
Subject Re: PostgreSQL vs. MySQL: fight
Date
Msg-id 20070814223413.GY54135@nasby.net
Whole thread Raw
In response to Re: PostgreSQL vs. MySQL: fight  (Josh Berkus <josh@agliodbs.com>)
Responses Re: PostgreSQL vs. MySQL: fight
List pgsql-advocacy
On Mon, Aug 13, 2007 at 10:16:15PM -0700, Josh Berkus wrote:
> Pavel,
>
> > I did't test MySQL three years, But three years ago, MySQL rollback
> > was really, really slow.
>
> Based on recent testing I did, rollbacks are very expensive -- like 3x to 4x
> the cost of the original insert in high-concurrency environments.  Also not
> always reliable (as of 5.0).

Wow, that's a serious gotcha. If there's a way to reproduce that we
should certainly let Ian Barwick of MySQL gotchas fame know about it.
--
Decibel!, aka Jim Nasby                        decibel@decibel.org
EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)

Attachment

pgsql-advocacy by date:

Previous
From: Decibel!
Date:
Subject: Re: 12 Silver Bullets
Next
From: Josh Berkus
Date:
Subject: Re: 12 Silver Bullets