Postgres Pro
Downloads
Home   >   mailing lists

Re: Foreign Key Deadlocking - Mailing list pgsql-performance

From Steven Flatt
Subject Re: Foreign Key Deadlocking
Date
Msg-id 357fa7590704181359q7622617et591962f218039da4@mail.gmail.com
Whole thread Raw
In response to Re: Foreign Key Deadlocking  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
Tree view
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
 

pgsql-performance by date:

Previous
From: Hannes Dorbath
Date:
Subject: Re: Equivalents in PostgreSQL of MySQL's "ENGINE=MEMORY" "MAX_ROWS=1000"
Next
From: "Merlin Moncure"
Date:
Subject: Re: Basic Q on superfluous primary keys