deadlock_timeout affect on performance

Поиск
Список
Период
Сортировка
От pg noob
Тема deadlock_timeout affect on performance
Дата
Msg-id CAPNY-2ULvbcLE9uuTG2=-Zhda+ghW63mPyrBirJ2VQRj=_2TVQ@mail.gmail.com
обсуждение исходный текст
Ответы Re: deadlock_timeout affect on performance  (Heikki Linnakangas <hlinnakangas@vmware.com>)
Список pgsql-performance

Hi all,

I have a question about the deadlock_timeout in regards to performance.
Right now we have this timeout set at its default of 1s.
My understanding of it is that this means that every 1 second the server will check for deadlocks.
What I am wondering is how much of a performance improvement we would expect to get if this was raised to 30 seconds?
Is it negligible or could it be a substantial performance improvement on a busy system?
We very rarely have deadlocks and waiting 30 seconds to discover one doesn't seem too bad.

Thank you.

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

Предыдущее
От: henk de wit
Дата:
Сообщение: Re: Spurious failure to obtain row lock possible in PG 9.1?
Следующее
От: Glyn Astill
Дата:
Сообщение: Re: hardware advice