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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-performance by date

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