Re: PostgreSQL vs. MySQL: fight

From: Decibel! <decibel(at)decibel(dot)org>
To: Lukas Kahwe Smith <smith(at)pooteeweet(dot)org>
Cc: Greg Smith <gsmith(at)gregsmith(dot)com>, pgsql-advocacy(at)postgresql(dot)org
Subject: Re: PostgreSQL vs. MySQL: fight
Date: 2007-08-10 21:11:07
Message-ID: 20070810211106.GH20424@nasby.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)decibel(dot)org
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)

In response to

Responses

Browse pgsql-advocacy by date

  From Date Subject
Next Message Jeff Davis 2007-08-10 22:04:30 Re: PostgreSQL vs. MySQL: fight
Previous Message Decibel! 2007-08-10 21:03:34 Re: Quality of email postings