Re: MySQL+InnoDB vs. PostgreSQL test?

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
Cc: pgsql-performance(at)postgresql(dot)org, pgsql-advocacy(at)postgresql(dot)org
Subject: Re: MySQL+InnoDB vs. PostgreSQL test?
Date: 2004-02-03 05:17:15
Message-ID: 200402022117.15918.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-advocacy pgsql-performance

Chris,

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

Unless you meant something else? Am I not following you?

--
-Josh Berkus
Aglio Database Solutions
San Francisco

In response to

Responses

Browse pgsql-advocacy by date

  From Date Subject
Next Message Christopher Kings-Lynne 2004-02-03 05:52:41 Re: MySQL+InnoDB vs. PostgreSQL test?
Previous Message Christopher Kings-Lynne 2004-02-03 04:55:27 Re: [PERFORM] MySQL+InnoDB vs. PostgreSQL test?

Browse pgsql-performance by date

  From Date Subject
Next Message Christopher Kings-Lynne 2004-02-03 05:52:41 Re: MySQL+InnoDB vs. PostgreSQL test?
Previous Message Christopher Kings-Lynne 2004-02-03 04:55:27 Re: [PERFORM] MySQL+InnoDB vs. PostgreSQL test?