Re: [GENERAL] Excessive Deadlocks On Concurrent Inserts to Shared Parent Row

2010-06-18 Thread Vick Khera
On Thu, Jun 17, 2010 at 2:14 PM, Marvin S. Addison wrote: > My impression at present is that the fundamental locking behavior of > PostgreSQL is poorly suited to applications that have both great deals of > concurrency and referential integrity.  This is of concern to us as we are > considering mi

[GENERAL] Excessive Deadlocks On Concurrent Inserts to Shared Parent Row

2010-06-17 Thread Marvin S. Addison
We're using PostgreSQL to back tickets in CAS, http://www.jasig.org/cas, in a large university environment where the ephemeral nature of CAS tickets places a high concurrent read/write workload on the database. We recently switched platforms from Oracle to PG and saw a dramatic increase in dead