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

From Decibel!
Subject Re: PostgreSQL vs. MySQL: fight
Date
Msg-id 20070810211106.GH20424@nasby.net
Whole thread Raw
In response to Re: PostgreSQL vs. MySQL: fight  (Lukas Kahwe Smith <smith@pooteeweet.org>)
Responses Re: PostgreSQL vs. MySQL: fight  (Jeff Davis <pgsql@j-davis.com>)
List pgsql-advocacy
On Fri, Aug 10, 2007 at 09:24:24AM +0200, Lukas Kahwe Smith wrote:
> Greg Smith wrote:
>
> >http://dev.mysql.com/doc/refman/5.0/en/innodb-next-key-locking.html
> >http://www.greatlinux.com/mysql/books/mysqlpress/mysql-tutorial/ch10.html
>
> I recently covered a related item (prevting phantom rows) regarding
> MySQL in my blog:
> http://pooteeweet.org/blog/745

Wait... isn't InnoDB an MVCC system? Why do they need gap locking at
all? Shouldn't they be able to just pull the right version?
--
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: Quality of email postings
Next
From: Jeff Davis
Date:
Subject: Re: PostgreSQL vs. MySQL: fight