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
