patrick keshishian wrote:
>>> Any method to kill such query would it still hang out there?
>>
>> One crude method would be to set statement_timeout to a nonzero
>> value - then queries that take longer than that many seconds
>> will be canceled.
> 
> you don't truly mean to advise that, do you? :)

Well, it might be useful as a kind of safeguard against
runaway queries that hog the server for hours.

If you expect that no reasonable query will take
more than a couple of minutes, you could set
statement_timeout=600 to kill anything that's still alive
after 10 minutes.

Yours,
Laurenz Albe



-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to