Re: Killing a Query

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.
>


I guess I should have read today's messages before posting.

Thanks, Anjan, for answering my question before I could ask it.

Kill -s SIGINT <pid of offending statement>