Re: Deferred constraints and locks...

From: Nathan Wilhelmi <wilhelmi(at)ucar(dot)edu>
To: pgsql-general(at)postgresql(dot)org
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Subject: Re: Deferred constraints and locks...
Date: 2008-02-12 20:48:46
Message-ID: 47B2062E.90503@ucar.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?
>
> regards, tom lane
>
>
Good question, is there anyway to figure out which rows are locked?

-Nate

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ivan Sergio Borgonovo 2008-02-12 20:48:56 Re: end of life for pg versions...
Previous Message Oliver Weichhold 2008-02-12 20:27:28 A couple PostgreSQL 8.3 related Fulltext-Search questions