Re: [GENERAL] (Never?) Kill Postmaster?

Pavel Stehule wrote:
> 2007/10/24, Stefan Schwarzer <stefan.schwarzer@grid.unep.ch>:
>
>> I read dozens of times the "TIP 2: Don't 'kill -9' the postmaster"...
>>
>> Now, what am I supposed to do if I launched a query which takes ages, and
>> which I want to interrupt?
> you have to use more gently way
>
> select pg_cancel_backend()
> http://www.postgresql.org/docs/current/interactive/functions-admin.html

The problem is that pg_cancel_backend() is somewhat unreliable at cancelling wayward queries. You can try other options for kill though, other than -9, which is kind of a last resort.

-- 
Tommy Gildseth


---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend