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.

Hmm... any ideas?

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.

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org/

Alvaro Herrera wrote:
> 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?
>
>
8.2