Foreign keys locking

From: James Pharaoh <james(at)pharaohsystems(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Foreign keys locking
Date: 2004-08-02 13:27:10
Message-ID: 1091453230.20919.27.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-hackers by date

  From Date Subject
Next Message Zoltan Bartko 2004-08-02 14:06:11 Re: psql i18n - sk
Previous Message Bruce Momjian 2004-08-02 12:46:55 Re: SQL conformance docs