Re: [GENERAL] Avoiding deadlocks on mass delete / update

2010-03-26 Thread Роман Маширов
Craig Ringer wrote: Роман Маширов wrote: I've got a simple 'spool' table, one process 'worker' reads and updates this table, other 'stat' performs 'delete ... where ... returning *'. Sometimes I've got dedlocks on delete operation in 'stat', seems like at the moment of expiration o

Re: [GENERAL] Avoiding deadlocks on mass delete / update

2010-03-23 Thread Craig Ringer
Роман Маширов wrote: > I've got a simple 'spool' table, one process 'worker' reads and updates > this table, other 'stat' performs 'delete ... where ... returning *'. > Sometimes I've got dedlocks on delete operation in 'stat', seems like at > the moment of expiration of data by timeout some state

[GENERAL] Avoiding deadlocks on mass delete / update

2010-03-22 Thread Роман Маширов
I've got a simple 'spool' table, one process 'worker' reads and updates this table, other 'stat' performs 'delete ... where ... returning *'. Sometimes I've got dedlocks on delete operation in 'stat', seems like at the moment of expiration of data by timeout some state changes arrived from work