Re: MySQL+InnoDB vs. PostgreSQL test? - Mailing list pgsql-advocacy

From Christopher Kings-Lynne
Subject Re: MySQL+InnoDB vs. PostgreSQL test?
Date
Msg-id 401F3729.9010202@familyhealth.com.au
Whole thread Raw
In response to Re: MySQL+InnoDB vs. PostgreSQL test?  (Josh Berkus <josh@agliodbs.com>)
List pgsql-advocacy
>>Um, wrong.   We don't lock rows for SELECT.
>
> Unless you meant something else?   Am I not following you?

I mean row level shared read lock.  eg. a lock that says, you can read
but you cannot delete.

It's what postgres needs to alleviate its foreign key trigger deadlock
problems.

Chris


pgsql-advocacy by date:

Previous
From: Christopher Browne
Date:
Subject: Re: MySQL+InnoDB vs. PostgreSQL test?
Next
From: Jeff
Date:
Subject: Re: [PERFORM] MySQL+InnoDB vs. PostgreSQL test?