Nathan Wilhelmi <wilhelmi@ucar.edu> 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