Thread: deadlock priority?

Hi. I have a query that does some batch deletes and inserts into a
table. It runs for 2-3 minutes when the application that uses the
database is  in production with users doing stuff.
Recently I have noticed that this query is a frequent victim of
deadlocks.

Is there any way to set a deadlock priority of this transaction or
some other setting so that it is never chosen as a deadlock victim if
only one instance of the transaction is running at the same time? All
other accesses to the table may be killed because of the deadlock but
not this query.

Sergei Shelukhin escribió:
> Hi. I have a query that does some batch deletes and inserts into a
> table. It runs for 2-3 minutes when the application that uses the
> database is  in production with users doing stuff.
> Recently I have noticed that this query is a frequent victim of
> deadlocks.

What Pg version are you using?

--
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

Sergei Shelukhin escribió: 

Hi. I have a query that does some batch deletes and inserts into a
table. It runs for 2-3 minutes when the application that uses the
database is  in production with users doing stuff.
Recently I have noticed that this query is a frequent victim of
deadlocks.   

What Pg version are you using?