| From: | paul rivers <rivers(dot)paul(at)gmail(dot)com> |
|---|---|
| To: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> |
| Cc: | Alvaro Herrera <alvherre(at)commandprompt(dot)com>, Ivan Sergio Borgonovo <mail(at)webthatworks(dot)it>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: postgre vs MySQL |
| Date: | 2008-03-13 04:07:23 |
| Message-ID: | 47D8A87B.8050906@gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Scott Marlowe wrote:
> On Wed, Mar 12, 2008 at 1:02 PM, paul rivers <rivers(dot)paul(at)gmail(dot)com> wrote:
>
>
>> - Auto_increment columns as pkeys in InnoDB tables are practically
>> required, yet severely limited scalability due to how a transaction
>> would lock the structure to get the next auto-increment (significantly
>> improved in 5.1)
>>
>
> Pretty sure they implemented the fix for that in an early 5.0 release.
> I remember chatting with Heikki Turri about it.
>
Definitely not fixed until 5.1, in fact not until very recently (5.1.22) :
http://bugs.mysql.com/bug.php?id=16979
Anyway, enough of that for me. It's a Postgres list, and my list of
MySQL complaints is far longer than my enthusiasm for documenting them.
Paul
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Scott Marlowe | 2008-03-13 04:30:57 | Re: Can't rename an existnig DB because it doesn't exist??? |
| Previous Message | Ow Mun Heng | 2008-03-13 03:45:24 | Re: Column Statistics - How to dertermine for whole database |