Re: foreign key locks, 2nd attempt - Mailing list pgsql-hackers

From Josh Berkus
Subject Re: foreign key locks, 2nd attempt
Date
Msg-id 4EBD9B58.5060108@agliodbs.com
Whole thread Raw
In response to Re: foreign key locks, 2nd attempt  (Bruce Momjian <bruce@momjian.us>)
List pgsql-hackers
>> An UPDATE that modifies the key columns will be blocked, just as now.
>> Same with a DELETE.
> 
> OK, so it prevents non-key data modifications from spilling to the
> referred rows --- nice.

Yes.  Eliminates the leading cause of deadlocks in Postgres applications.

-- 
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com


pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: why do we need two snapshots per query?
Next
From: Tom Lane
Date:
Subject: Re: why do we need two snapshots per query?