Tino Schwarze <[EMAIL PROTECTED]> writes:
> So I'd like to watch for transactions waiting for the lock in step 3 - I
> do not care for the time it took to perform the work.
Dunno if this is of any use to you, but there is a "log_lock_waits"
feature in CVS HEAD that seems to be exactly what you wan
On Wed, Sep 12, 2007 at 05:02:56PM -0500, Scott Marlowe wrote:
> > is there an easy way to detect locks which are held for a very long
> > time? We've got some problems with a database here where a lock is held
> > for 1 or 2 hours though the operation should be very quick. A lot of
> > other proc
On 9/12/07, Tino Schwarze <[EMAIL PROTECTED]> wrote:
> Hi there,
>
> is there an easy way to detect locks which are held for a very long
> time? We've got some problems with a database here where a lock is held
> for 1 or 2 hours though the operation should be very quick. A lot of
> other processes
Hi there,
is there an easy way to detect locks which are held for a very long
time? We've got some problems with a database here where a lock is held
for 1 or 2 hours though the operation should be very quick. A lot of
other processes are then waiting for the lock to become available.
We would li
