Postgres Pro
Downloads
Home   >   mailing lists

Re: Cancelling long running query? - Mailing list pgsql-novice

From Josh Berkus
Subject Re: Cancelling long running query?
Date
Msg-id 200211111158.49538.josh@agliodbs.com
Whole thread Raw
In response to Cancelling long running query?  ("Patrick Hatcher" <PHatcher@macys.com>)
Responses Re: Cancelling long running query?
List pgsql-novice
Tree view 
Patrick,

> How can I cancel a long running query besides quitting the app?
> TIA

Methods:
1) Shutdown and restart the database server with pg_ctl -m fast restart.
2) Kill the client connection proccess on the server side.  This is dangerous
if the long-running query is a data-modification query.


--
-Josh Berkus
 Aglio Database Solutions
 San Francisco

pgsql-novice by date:

Previous
From: "Patrick Hatcher"
Date:
Subject: Cancelling long running query?
Next
From: Tom Lane
Date:
Subject: Re: Cancelling long running query?