Re: lock timeout patch - Mailing list pgsql-hackers

From Satoshi Nagayasu
Subject Re: lock timeout patch
Date
Msg-id 40DFA06E.5010206@noanet06.noanet.nttdata.co.jp
Whole thread Raw
In response to Re: lock timeout patch  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: lock timeout patch
List pgsql-hackers
statement_timeout terminates large sort or scan
even if it is running, doesn't it?

statement_timeout doesn't care that
the process is waiting a lock or running.
I don't want to terminate a running query.

So a lock waiting backend shold be killed.

Tom Lane wrote:
> Satoshi Nagayasu <nagayasus@nttdata.co.jp> writes:
> 
>>I guess the transaction cancellation from the client
>>using PQrequestCancel() is available, but the cancellation
>>logic must be implemented in the client-application using
>>signal or thread.
> 
> 
> Actually I think the recommended solution involves using statement_timeout.
> 
>             regards, tom lane
> 


-- 
NAGAYASU Satoshi <nagayasus@nttdata.co.jp>


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: lock timeout patch
Next
From: Tom Lane
Date:
Subject: Re: lock timeout patch