explicit deadlock-victim-priority mechanism

Поиск
Список
Период
Сортировка
От
Тема explicit deadlock-victim-priority mechanism
Дата
Msg-id F3CBFBA88397EA498B22A05FFA9EC49D4C38A581@MX22A.corp.emc.com
обсуждение исходный текст
Список pgsql-general
ref =  [ E1QZDJc-0000XV-C8@gemulon.postgresql.org ]

I note with interest that [deadlock_timeout] can be used as . . .
"a poor-man's deadlock priority mechanism: a transaction with a high [deadlock_timeout] is less
likely to be chosen as the victim than one with a low [deadlock_timeout]"

I for one, would definitely be interested in "a more explicit priority mechanism".

My use case is:
We have some "batch work" processes, whose "deadlock-victim-priority" I would like to set to HIGH.
(at the expense of smaller transactions who I would like to be the victim)

-dvs-




В списке pgsql-general по дате отправления:

Предыдущее
От: "Rob_pg"
Дата:
Сообщение: Re: writing a foreign data wrapper for hdfs, but getting and undefined symbol error for hdfsConnect
Следующее
От: Tom Lane
Дата:
Сообщение: Re: writing a foreign data wrapper for hdfs, but getting and undefined symbol error for hdfsConnect