Killing a Query

From: Brandon Hines <brandon(at)2i(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Killing a Query
Date: 2005-05-13 18:31:51
Message-ID: 4284F297.8000901@2i.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin


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.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Kavan, Dan (IMS) 2005-05-13 18:57:05 Re: version 8.0.3
Previous Message Kavan, Dan (IMS) 2005-05-13 18:09:08 version 8.0.3