Re: FKs and deadlocks

Stephan Szabo <sszabo@megazone.bigpanda.com> writes:
> On Fri, 22 Oct 2004, Philippe Lang wrote:
>> I don't know if anyone has a better idea, but I would like to try taking
>> away some FKs in my schema. My problem is that I really don't know which
>> one to delete. There are over 40 tables. Are there rules to do that? Or
>> maybe can I simply wait on the next deadlock, and try understanding who
>> got locked by who? OK, but how can I do that?

> I think you may be able to do this if you turn on statement locking and
> try to resurrect the state from the logs.

Also look in pg_locks and pg_activity.

            regards, tom lane