Re: obtaining row locking information - Mailing list pgsql-hackers

From Tom Lane
Subject Re: obtaining row locking information
Date
Msg-id 28769.1123515317@sss.pgh.pa.us
Whole thread Raw
In response to Re: obtaining row locking information  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
List pgsql-hackers
Alvaro Herrera <alvherre@alvh.no-ip.org> writes:
> All in all, Tatsuo is right in that there's no way to know what tuples
> are locked without scanning the whole table.

Sure.  I was just questioning how much one needs to know that.  It seems
to me that the only time you really care is when you are investigating
a hangup, and then you can get useful info from pg_locks.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: obtaining row locking information
Next
From: "Joshua D. Drake"
Date:
Subject: Re: shrinking the postgresql.conf