Pavel Stehule wrote:
2007/10/24, Stefan Schwarzer <stefan.schwarzer@xxxxxxxxxxxx>:
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
