: Wednesday, February 18, 2015 6:19 AM
To: Dmitry O Litvintsev
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] postgresql93-9.3.5: deadlock when updating parent table
expected?
Dmitry O Litvintsev wrote:
Hi,
I recently updated to postgresql93-9.3.5 (from 9.2.9). I see frequent
deadlocks
when
On Wed, 18 Feb 2015 18:30:09 +
Dmitry O Litvintsev litvi...@fnal.gov wrote:
Yes, deadlock occurs when there are multiple processes insert
concurrently into file table with the same volume id field.
I used sometimes as opposed to all the time.
I resonded in that way since I frequently
Thank you, Bill,
Yes, deadlock occurs when there are multiple processes insert
concurrently into file table with the same volume id field.
I used sometimes as opposed to all the time.
I think you advise to retry transaction or add select for update prior
to insert. I will pursue this
Hi,
If you feel FOR UPDATE is taking much time, then I believe,we can solve
this kind of issues using advisory locks
http://www.postgresql.org/docs/9.1/static/explicit-locking.html, .
Regards,
Dinesh
manojadinesh.blogspot.com
On Wed, Feb 18, 2015 at 10:45 AM, Bill Moran
On Wed, 18 Feb 2015 04:55:47 +
Dmitry O Litvintsev litvi...@fnal.gov wrote:
Hi,
I recently updated to postgresql93-9.3.5 (from 9.2.9). I see frequent
deadlocks
when updating parent table in insert into child table. There is foreign key
constraint between
child table and parent
Dmitry O Litvintsev wrote:
Hi,
I recently updated to postgresql93-9.3.5 (from 9.2.9). I see frequent
deadlocks
when updating parent table in insert into child table. There is foreign key
constraint between
child table and parent table. Parent table is updated on by trigger in insert
Hi,
I recently updated to postgresql93-9.3.5 (from 9.2.9). I see frequent deadlocks
when updating parent table in insert into child table. There is foreign key
constraint between
child table and parent table. Parent table is updated on by trigger in insert
into child table. So
pretty much