Postgres Pro
Downloads
Home   >   mailing lists

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

From Josh Berkus
Subject Re: [pgsql-advocacy] MySQL+InnoDB vs. PostgreSQL test?
Date
Msg-id 200402021941.57516.josh@agliodbs.com
Whole thread Raw
In response to Re: [pgsql-advocacy] MySQL+InnoDB vs. PostgreSQL test?  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
Responses Re: [pgsql-advocacy] MySQL+InnoDB vs. PostgreSQL test?  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: [pgsql-advocacy] MySQL+InnoDB vs. PostgreSQL test?  (Josh Berkus <josh@agliodbs.com>)
List pgsql-performance
Tree view 
Chris,

> 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...

Um, wrong.   We don't lock rows for SELECT.

--
-Josh Berkus

______AGLIO DATABASE SOLUTIONS___________________________
                                        Josh Berkus
   Complete information technology     josh@agliodbs.com
    and data management solutions     (415) 565-7293
   for law firms, small businesses      fax 621-2533
    and non-profit organizations.     San Francisco

pgsql-performance by date:

Previous
From: Christopher Kings-Lynne
Date:
Subject: Re: [pgsql-advocacy] MySQL+InnoDB vs. PostgreSQL test?
Next
From: Tom Lane
Date:
Subject: Re: [pgsql-advocacy] MySQL+InnoDB vs. PostgreSQL test?