Alexander Staubo <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly