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.
>=20
> 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=3D600 to kill anything that's still alive
after 10 minutes.
Yours,
Laurenz Albe