Jan Wieck wrote:
On 2/12/2008 3:04 PM, Tom Lane wrote:
Nathan Wilhelmi <[EMAIL PROTECTED]> 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 h
On 2/12/2008 3:04 PM, Tom Lane wrote:
Nathan Wilhelmi <[EMAIL PROTECTED]> 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
Nathan Wilhelmi <[EMAIL PROTECTED]> writes:
> Tom Lane wrote:
>> Insert statements would naturally take RowExclusiveLock, but that
>> doesn't block other DML operations. So the question is what *else*
>> are you doing?
> Good question, is there anyway to figure out which rows are locked?
RowExcl
Tom Lane wrote:
Nathan Wilhelmi <[EMAIL PROTECTED]> 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 othe
Nathan Wilhelmi <[EMAIL PROTECTED]> 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
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 up
