Tom Lane wrote:
Nathan Wilhelmi <wilhelmi@xxxxxxxx> writes:
Hello - Trying to track down a lock contention problem, I have a process
that does a series of select / insert operations. At some point the
process grabs a series of RowExclusiveLock(s) and has the obvious effect
of stalling other processes. I logged all the statements and don't see
any for update or explicit lock statements.
Insert statements would naturally take RowExclusiveLock, but that
doesn't block other DML operations. So the question is what *else*
are you doing?
regards, tom lane
Good question, is there anyway to figure out which rows are locked?
-Nate
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
message can get through to the mailing list cleanly
