Thread: Foreign keys locking

Foreign keys locking

From
James Pharaoh
Date:
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