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

From Christopher Kings-Lynne
Subject Re: MySQL+InnoDB vs. PostgreSQL test?
Date
Msg-id 401F0FCD.70903@familyhealth.com.au
Whole thread Raw
In response to Re: MySQL+InnoDB vs. PostgreSQL test?  (Jan Wieck <JanWieck@Yahoo.com>)
Responses Re: MySQL+InnoDB vs. PostgreSQL test?
List pgsql-advocacy
> Seriously, I am tired of this kind of question. You gotta get bold
> enough to stand up in a "meeting" like that, say "guy's, you can ask me
> how this compares to Oracle ... but if you're seriously asking me how
> this compares to MySQL, call me again when you've done your homework".

Hey at least I noticed that InnoDB has one essential feature we don't:

SELECT ... IN SHARE MODE;

Which does a shared lock on a row as opposed to a write lock, hence
avoiding nasty foreign key deadlocks...

Chris


pgsql-advocacy by date:

Previous
From: Jan Wieck
Date:
Subject: Re: MySQL+InnoDB vs. PostgreSQL test?
Next
From: Josh Berkus
Date:
Subject: Re: MySQL+InnoDB vs. PostgreSQL test?