On 2/12/2008 3:04 PM, 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?
Those SELECT statements aren't by chance FOR UPDATE, are they?
Jan
--
Anyone who trades liberty for security deserves neither
liberty nor security. -- Benjamin Franklin
---------------------------(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
