Re: Killing a Query

I use kill -s SIGINT <pid of bad query>

Thanks,
Anjan

-----Original Message-----
From: Brandon Hines [mailto:brandon(at)2i(dot)com]
Sent: Friday, May 13, 2005 2:32 PM
To: pgsql-admin(at)postgresql(dot)org
Subject: [ADMIN] Killing a Query

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