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: (view raw or whole 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...


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-2015 The PostgreSQL Global Development Group