Re: Stuck in "DELETE waiting"

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Alexander Staubo <alex(at)purefiction(dot)net>
Cc: PgSQL General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Stuck in "DELETE waiting"
Date: 2006-11-23 16:21:13
Message-ID: 13957.1164298873@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Alexander Staubo <alex(at)purefiction(dot)net> writes:
> See below. Seems 18204 is waiting for a process that is "idle in
> transaction"; makes me wish that PostgreSQL could export more
> information about the age of in-progress transactions. I am turning
> on logging so I can determine what a future hanging process is doing.

Yeah, it looks like PIDs 18202 and 18207 are the bottlenecks, and they
are not waiting on locks.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ron Johnson 2006-11-23 16:23:55 Re: IS it a good practice to use SERIAL as Primary Key?
Previous Message Alexander Staubo 2006-11-23 15:57:32 Re: Stuck in "DELETE waiting"