pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed

deadlock_timeout parameter in Postgresql.cof
3+ messages / 2 participants
[nested] [flat]

* deadlock_timeout parameter in Postgresql.cof
@ 2007-08-23 18:21  Sachchida Ojha <sojha@secure-elements.com>
  0 siblings, 0 replies; 3+ messages in thread

From: Sachchida Ojha @ 2007-08-23 18:21 UTC (permalink / raw)
  To: 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 <mailto:sojha@secure-elements.com> 

Secure Elements Incorporated

198 Van Buren Street, Suite 110

Herndon Virginia 20170-5338 USA

 

http://www.secure-elements.com/ <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.

 

^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* deadlock_timeout parameter in Postgresql.cof
@ 2007-08-23 18:23  Sachchida Ojha <sojha@secure-elements.com>
  0 siblings, 1 reply; 3+ messages in thread

From: Sachchida Ojha @ 2007-08-23 18:23 UTC (permalink / raw)
  To: 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

sachi

 

 

^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: deadlock_timeout parameter in Postgresql.cof
@ 2007-08-23 18:52  Bill Moran <wmoran@collaborativefusion.com>
  parent: Sachchida Ojha <sojha@secure-elements.com>
  0 siblings, 0 replies; 3+ messages in thread

From: Bill Moran @ 2007-08-23 18:52 UTC (permalink / raw)
  To: Sachchida Ojha <sojha@secure-elements.com>; +Cc: pgsql-performance

In response to "Sachchida Ojha" <sojha@secure-elements.com>:

> 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 ? 

Does the documentation leave anything unanswered?
http://www.postgresql.org/docs/8.2/static/runtime-config-locks.html

-- 
Bill Moran
Collaborative Fusion Inc.
http://people.collaborativefusion.com/~wmoran/

wmoran@collaborativefusion.com
Phone: 412-422-3463x4023



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

end of thread, other threads:[~2007-08-23 18:52 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-08-23 18:21 deadlock_timeout parameter in Postgresql.cof Sachchida Ojha <sojha@secure-elements.com>
2007-08-23 18:23 deadlock_timeout parameter in Postgresql.cof Sachchida Ojha <sojha@secure-elements.com>
2007-08-23 18:52 ` Bill Moran <wmoran@collaborativefusion.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox