Re: obtaining row locking information

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: obtaining row locking information
Дата
Msg-id 28769.1123515317@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: obtaining row locking information  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
Список 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 по дате отправления:

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: obtaining row locking information
Следующее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: shrinking the postgresql.conf