Re: Foreign Key Deadlocking - Mailing list pgsql-performance

From Tom Lane
Subject Re: Foreign Key Deadlocking
Date
Msg-id 5757.1176918457@sss.pgh.pa.us
Whole thread Raw
In response to Foreign Key Deadlocking  ("Steven Flatt" <steven.flatt@gmail.com>)
Responses Re: Foreign Key Deadlocking
List pgsql-performance
"Steven Flatt" <steven.flatt@gmail.com> writes:
> Hi, we're using Postgres 8.1.4.
> We've been seeing deadlock errors of this form, sometimes as often as
> several times per hour:
> ...
> I also see claims that this problem is fixed in 8.2, and if the fix is what
> I think it is, it's also in 8.1.6.
> Can someone confirm that I've identified the right fix?

Hard to say without a lot more data, but as a general rule you should be
on 8.1.latest in any case.  See
http://www.postgresql.org/support/versioning
You might also find ammunition in the release notes:
http://developer.postgresql.org/pgdocs/postgres/release.html

            regards, tom lane

pgsql-performance by date:

Previous
From: "Jim C. Nasby"
Date:
Subject: Re: Shared buffers, db transactions commited, and write IO on Solaris
Next
From: "Jim C. Nasby"
Date:
Subject: Re: a question about Direct I/O and double buffering