| From: | Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at> |
|---|---|
| To: | "patrick keshishian *EXTERN*" <pkeshish(at)gmail(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Terminate query on page exit |
| Date: | 2013-02-19 12:42:03 |
| Message-ID: | A737B7A37273E048B164557ADEF4A58B057B522A@ntex2010a.host.magwien.gv.at |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2013-02-19 14:25:06 | Re: Connection with server dropping out |
| Previous Message | Pavel Stehule | 2013-02-19 12:38:13 | Re: Terminate query on page exit |