Re: Update problem on large table

On Mon, Dec 6, 2010 at 1:46 PM, bricklen <bricklen@gmail.com> wrote:
> On Sat, Dec 4, 2010 at 11:45 AM, felix <crucialfelix@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.

How does this differ from just killing the pid?

--
Jon