On Thu, Apr 06, 2006 at 03:36:33PM -0400, Emi Lu wrote:
> How to check whether a table is locked?
You can monitor locks by querying the pg_locks view.
http://www.postgresql.org/docs/8.0/interactive/monitoring-locks.html
http://www.postgresql.org/docs/8.0/interactive/view-pg-locks.html
Only a few operations lock entire tables; for more information see
the Concurrency Control chapter in the documentation.
http://www.postgresql.org/docs/8.0/interactive/mvcc.html
> Is there a way that I can find all deadlocks under postgresql 8.0.1 ?
Are you sure you mean "deadlocks"? Deadlock occurs when transaction
A holds a lock that transaction B wants and transaction B holds a
lock that transaction A wants; PostgreSQL detects this condition
and aborts one of the transactions, allowing the other to continue.
By default this happens after one second (see the deadlock_timeout
setting).
Perhaps you want to see pending or blocked lock attempts, i.e.,
locks that have been requested but are not yet acquired because
another transaction holds a conflicting lock. If that's the case
then look for rows in pg_locks where "granted" is false.
--
Michael Fuhr