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>
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
