Re: Foreign Key Deadlocking

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: "Tom Lane" <tgl@xxxxxxxxxxxxx>
Subject: Re: Foreign Key Deadlocking
From: "Steven Flatt" <steven.flatt@xxxxxxxxx>
Date: Wed, 18 Apr 2007 16:59:03 -0400
Cc: pgsql-performance@xxxxxxxxxxxxxx
In-reply-to: <5757.1176918457@xxxxxxxxxxxxx>
References: <357fa7590704180807j1906d42u1f0f539ac561dc3e@xxxxxxxxxxxxxx> <5757.1176918457@xxxxxxxxxxxxx>

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

References:
- Foreign Key Deadlocking
  - From: Steven Flatt
- Re: Foreign Key Deadlocking
  - From: Tom Lane

Prev by Date: Re: Equivalents in PostgreSQL of MySQL's "ENGINE=MEMORY" "MAX_ROWS=1000"
Next by Date: Re: Basic Q on superfluous primary keys
Previous by thread: Re: Foreign Key Deadlocking
Next by thread: how to output column names
Index(es):
- Date
- Thread

[Postgresql General] [Postgresql PHP] [PHP Users] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Yosemite]

Powered by Linux