Postgres Pro
Downloads
Home   >   mailing lists

Re: Seeing locks (was Status of gist locking in 8.1.3) - Mailing list pgsql-general

From Tom Lane
Subject Re: Seeing locks (was Status of gist locking in 8.1.3)
Date
Msg-id 24547.1149005738@sss.pgh.pa.us
Whole thread Raw
In response to Seeing locks (was Status of gist locking in 8.1.3)  (Francisco Reyes <lists@stringsutils.com>)
List pgsql-general
Tree view 
Francisco Reyes <lists@stringsutils.com> writes:
> The two records I always see are:
>    locktype    |....|      mode       | granted
> ---------------+....+-----------------+---------
>  transactionid |....| ExclusiveLock   | t
>  relation      |....| AccessShareLock | t

That would be your own transaction's lock on its own XID, and its share
lock on the pg_locks view.  Joining to pg_database.oid and pg_class.oid
will help you interpret the numbers --- see
http://www.postgresql.org/docs/8.1/static/view-pg-locks.html

            regards, tom lane

pgsql-general by date:

Previous
From: Francisco Reyes
Date:
Subject: Seeing locks (was Status of gist locking in 8.1.3)
Next
From: "Philippe Lang"
Date:
Subject: Which RPM for RH Linux ES 4? PGDB or RH?