Re: How to stop a query

Hi Scott,

thank you for your comment

2012/7/19 Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>

> On Thu, Jul 19, 2012 at 3:17 AM, younus <younus(dot)essahli(at)gmail(dot)com> wrote:
> > Hi,
> >
> > First :
> > ps -ef | grep postgres
> > and kill -9 (PID of your query)
>
> NEVER kill -9 a postgres process unless you've exhausted all other
> possibilities, as it forces a restart of all the other backends as
> well. A plain kill (no -9) is usually all you need, and it doesn't
> cause all the other backends to restart and flush all shared memory.
>
> > Sec :
> > select procpid, datname, usename, client_addr, current_query from
> > pg_stat_activity where current_query!='<IDLE>';
> >
> > and
> >
> > SELECT pg_cancel_backend(procpid);
>
> MUCH better way of doing things.
>