deadlock_timeout parameter in Postgresql.cof - Mailing list pgsql-performance

From Sachchida Ojha
Subject deadlock_timeout parameter in Postgresql.cof
Date
Msg-id E099DB9EF394534CBA0F62ED03CF3BBF06077E93@EXVS01.IceMAIL.com
Whole thread Raw
List 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 by date:

Previous
From: Stephen Davies
Date:
Subject: Re: Optimising "in" queries
Next
From: "Sachchida Ojha"
Date:
Subject: deadlock_timeout parameter in Postgresql.cof