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 Moncure||Date: 2007-04-19 00:16:18|
|Subject: Re: Basic Q on superfluous primary keys|
|Previous:||From: Hannes Dorbath||Date: 2007-04-18 20:04:56|
|Subject: Re: Equivalents in PostgreSQL of MySQL's "ENGINE=MEMORY" "MAX_ROWS=1000"|