Re: PostgreSQL vs. MySQL: fight

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)