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>