Re: deadlock_timeout - Mailing list pgsql-hackers

From Simon Riggs
Subject Re: deadlock_timeout
Date
Msg-id 1215444921.4051.607.camel@ebony.site
Whole thread Raw
In response to Re: deadlock_timeout  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Mon, 2008-07-07 at 11:16 -0400, Tom Lane wrote:
> Simon Riggs <simon@2ndquadrant.com> writes:
> > Why is deadlock_timeout set at SIGHUP?
> 
> Because it's not clear what the behavior would be like if different
> backends had different settings ... except that it'd probably be
> surprising.

Yeh, agreed. I was thinking to set the deadlock_timeout the same for all
people running the deadlock-prone transactions and set it higher for
others. 

-- Simon Riggs           www.2ndQuadrant.comPostgreSQL Training, Services and Support



pgsql-hackers by date:

Previous
From: Bernd Helmle
Date:
Subject: Re: Schema-qualified statements in pg_dump output
Next
From: Peter Eisentraut
Date:
Subject: Re: Proposal of SE-PostgreSQL patches [try#2]