On Sat, Dec 4, 2010 at 11:45 AM, felix <[email protected]> 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 ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
