On Sat, Dec 4, 2010 at 11:45 AM, felix <crucialfelix(at)gmail(dot)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.
In response to
pgsql-performance by date
|Next:||From: Jon Nelson||Date: 2010-12-06 19:48:47|
|Subject: Re: Update problem on large table|
|Previous:||From: Robert Haas||Date: 2010-12-06 19:07:05|
|Subject: Re: Performance under contention|