On Sun, Sep 26, 2004 at 08:55:46PM -0400, Shawn Chisholm wrote:
> Hi all, quick question related to some scalability problems I
> have been seeing: do foreign key references acquire write locks on
> the row they are referencing during an insert, and are these locks
> held until the end of the transaction?
This was recently brought up in pgsql-general -- see the original
message and my followup:
http://archives.postgresql.org/pgsql-general/2004-09/msg00405.php
--
Michael Fuhr
http://www.fuhr.org/~mfuhr/