[GENERAL] Avoiding deadlocks on mass delete / update

[Роман Маширов]

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 worker. So the question, is it possible to somehow set order of row 
deletion in such bulk delete operation, to avoid deadlocks?

Thank you beforehand
--
MRJ
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general