On Sat, Dec 4, 2010 at 11:45 AM, felix <crucialfe...@gmail.com> wrote: > Ok, I caught one : an update that is stuck in waiting. > the first one blocks the second one. > ns | 5902 | nssql | UPDATE "fastadder_fastadderstatus" SET "built" > = false WHERE "fastadder_fastadderstatus"."service_id" = 1
Not sure if anyone replied about killing your query, but you can do it like so: select pg_cancel_backend(5902); -- assuming 5902 is the pid of the query you want canceled. -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
