Quick Links

Re: Foreign key deadlocks

From:	Michael Fuhr <mike(at)fuhr(dot)org>
To:	Shawn Chisholm <ShawnC(at)sandvine(dot)com>
Cc:	pgsql-novice(at)postgresql(dot)org
Subject:	Re: Foreign key deadlocks
Date:	2004-09-27 01:37:08
Message-ID:	20040927013707.GA18234@winnie.fuhr.org
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	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/

In response to

Foreign key deadlocks at 2004-09-27 00:55:46 from Shawn Chisholm

Responses

NOTICE: adding missing FROM-clause entry for table at 2004-09-28 01:51:14 from Kumar S
Duplicate entries with different primary keys (SERIAL) at 2004-09-28 02:11:57 from Kumar S

Browse pgsql-novice by date

	From	Date	Subject
Next Message	Mark Stosberg	2004-09-27 17:57:52	Re: Calculation Functions between Columns
Previous Message	Shawn Chisholm	2004-09-27 00:55:46	Foreign key deadlocks