Hi Scott, thank you for your comment
2012/7/19 Scott Marlowe <scott.marl...@gmail.com> > On Thu, Jul 19, 2012 at 3:17 AM, younus <younus.essa...@gmail.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. >
