Re: Killing a Query

if i remember correctly, kill -TERM <the procpid of the query> should do
it. you can get the pid of the query process by looking at pg_queries
table

Vikram

ps: be careful you dont kill -9 or some such.....

On Fri, 13 May 2005, Brandon Hines wrote:

>
> Is there a method for killing a query from the server.
>
> I have a number of users that manage to run queries that busy the server
> preventing a number of critical queries from running within an
> acceptable time limit.
>
> I would like to kill off the queries that appear to be busying the
> server without having to take postgres down altogether.
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>