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 ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
