Re: Deferred constraints and locks...

On 2/12/2008 3:04 PM, Tom Lane wrote:
> Nathan Wilhelmi <wilhelmi(at)ucar(dot)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?

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