Help with database locking - Mailing list pgsql-general

From Matt Beauregard
Subject Help with database locking
Date
Msg-id 20010225124506.H352@designscape.com.au
Whole thread Raw
List pgsql-general
We're having awful trouble with something getting locks on one of our
tables (or locks on something) and shutting out other clients.  Is
there a way of getting a list of what locks are active, or logging
them as they're set and unset?  Do locks have a timeout, and can we
adjust it?  We're running 7.0.3.  Any suggestions would be greatly
appreciated.


--
Matt Beauregard
Information Technology Operations, DesignScape

Ph: +61 2 9361 4233   Fx: +61 2 9361 4633

pgsql-general by date:

Previous
From: "Dan Wilson"
Date:
Subject: Re: version issue?
Next
From: Ian Harding
Date:
Subject: Re: Problem with PL/pgSQL