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

Re: Foreign Key Deadlocking

From: "Steven Flatt" <steven(dot)flatt(at)gmail(dot)com>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Foreign Key Deadlocking
Date: 2007-04-18 20:59:03
Message-ID: 357fa7590704181359q7622617et591962f218039da4@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-performance
Thanks for your answers and feedback.

All things considered, it is easiest (and acceptable) in this case to remove
RI between the tables where the deadlocks were occurring.

We are still looking to upgrade to 8.1.latest but that is another matter...

Steve

In response to

pgsql-performance by date

Next:From: Merlin MoncureDate: 2007-04-19 00:16:18
Subject: Re: Basic Q on superfluous primary keys
Previous:From: Hannes DorbathDate: 2007-04-18 20:04:56
Subject: Re: Equivalents in PostgreSQL of MySQL's "ENGINE=MEMORY" "MAX_ROWS=1000"

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