Skip site navigation (1) Skip section navigation (2)

Re: Foreign Key Deadlocking

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Steven Flatt" <steven(dot)flatt(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Foreign Key Deadlocking
Date: 2007-04-18 17:47:37
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-performance
"Steven Flatt" <steven(dot)flatt(at)gmail(dot)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
You might also find ammunition in the release notes:

			regards, tom lane

In response to


pgsql-performance by date

Next:From: Jim C. NasbyDate: 2007-04-18 18:07:59
Subject: Re: a question about Direct I/O and double buffering
Previous:From: Jim C. NasbyDate: 2007-04-18 17:19:59
Subject: Re: Shared buffers, db transactions commited, and write IO on Solaris

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group