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 <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend