Josh Berkus <josh(at)agliodbs(dot)com> writes:
>> How can I cancel a long running query besides quitting the app?
> 1) Shutdown and restart the database server with pg_ctl -m fast restart.
Better is just to send SIGINT to the individual backend running the
query. This is equivalent to the client having made a QueryCancel
> 2) Kill the client connection proccess on the server side. This is dangerous
> if the long-running query is a data-modification query.
No more dangerous than any other forced database crash ... which is what
you will get if you kill a backend process ...
regards, tom lane
In response to
- SQL at 2002-11-12 06:45:37 from cristi
pgsql-novice by date
|Next:||From: Lakshmi Narayanan V||Date: 2002-11-12 01:40:04|
|Subject: Invlalid EUC_JP character |
|Previous:||From: Josh Berkus||Date: 2002-11-11 19:58:49|
|Subject: Re: Cancelling long running query?|