deadlock_timeout parameter in Postgresql.cof

Поиск
Список
Период
Сортировка
От Sachchida Ojha
Тема deadlock_timeout parameter in Postgresql.cof
Дата
Msg-id E099DB9EF394534CBA0F62ED03CF3BBF06077E93@EXVS01.IceMAIL.com
обсуждение исходный текст
Список pgsql-performance

I am having some dead locking problem with my app system. Our dev are debugging the app to find out the cause of the problem. In the mean time I looked at postgresql.conf file. I found that there is a parameter in postgresql.conf file deadlock_timeout which was set 1000 (ms).  Normally I see deadlock in the night or when auto vacuum is running for a long time.

 

My question is

 

What is the significance of this parameter and updating this parameter value will make any difference ?

 

Thanks

Regards

Sachchida N Ojha

sojha@secure-elements.com

Secure Elements Incorporated

198 Van Buren Street, Suite 110

Herndon Virginia 20170-5338 USA

 

http://www.secure-elements.com/

 

800-709-5011 Main

703-709-2168 Direct

703-709-2180 Fax

This email message and any attachment to this email message is intended only for the use of the addressee(s) named above. If the reader of this message is not the intended recipient or the employee or agent responsible for delivering the message to the intended recipient(s), please note that any distribution or copying of this communication is strictly prohibited.  If you have received this email in error, please notify me immediately and delete this message.  Please note that if this email contains a forwarded message or is a reply to a prior message, some or all of the contents of this message or any attachments may not have been produced by the sender.

 

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

Предыдущее
От: Stephen Davies
Дата:
Сообщение: Re: Optimising "in" queries
Следующее
От: "Sachchida Ojha"
Дата:
Сообщение: deadlock_timeout parameter in Postgresql.cof