Re: Notice lock waits

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Notice lock waits
Дата
Msg-id 17899.1470424648@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Notice lock waits  (Jeff Janes <jeff.janes@gmail.com>)
Ответы Re: Notice lock waits  (Jeff Janes <jeff.janes@gmail.com>)
Список pgsql-hackers
Jeff Janes <jeff.janes@gmail.com> writes:
> I have it PGC_SUSET because it does send some tiny amount of
> information about the blocking process (the PID) to the blocked
> process.  That is probably too paranoid, because the PID can be seen
> by anyone in the pg_locks table anyway.

Why not just leave out the PID?  I think it's often far too simplistic
to blame a lock wait on a single other process, anyway.
        regards, tom lane



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Julien Rouhaud
Дата:
Сообщение: Re: Notice lock waits
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: Heap WARM Tuples - Design Draft