Re: Foreign key deadlocks
| От | Michael Fuhr |
|---|---|
| Тема | Re: Foreign key deadlocks |
| Дата | |
| Msg-id | 20040927013707.GA18234@winnie.fuhr.org обсуждение исходный текст |
| Ответ на | Foreign key deadlocks ("Shawn Chisholm" <ShawnC@sandvine.com>) |
| Ответы |
NOTICE: adding missing FROM-clause entry for table
Duplicate entries with different primary keys (SERIAL) |
| Список | pgsql-novice |
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/
В списке pgsql-novice по дате отправления: