Help with database locking

From: Matt Beauregard <matt(at)designscape(dot)com(dot)au>
To: pgsql-general(at)postgresql(dot)org
Subject: Help with database locking
Date: 2001-02-25 01:45:06
Message-ID: 20010225124506.H352@designscape.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-general by date

  From Date Subject
Next Message Ian Harding 2001-02-25 03:06:45 Re: Problem with PL/pgSQL
Previous Message Aristide Aragon 2001-02-25 01:11:19 Help with pq++