Re: Deferred constraints and locks...

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