Foreign keys locking - Mailing list pgsql-hackers

From James Pharaoh
Subject Foreign keys locking
Date
Msg-id 1091453230.20919.27.camel@localhost.localdomain
Whole thread Raw
List pgsql-hackers
Hi,

I am using postgresql for a system, and having a lot of deadlocks due to
foreign keys. I am aware of the situation regarding this from browsing
the mailing list archives.

As I understand it the solution is to implement dirty reads and modify
the referential integrity triggers to use these instead of for update
locks.

How much work is involved in getting this done? Is interested in getting
paid to undertake this?

Please contact my email directly as I am not subscribed to this list.

James Pharaoh




pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Fwd: init scripts and su
Next
From: "Hicham G. Elmongui"
Date:
Subject: error in linking