Re: logging of transaction related events

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: logging of transaction related events
Дата
Msg-id 200711212243.lALMhp815055@momjian.us
обсуждение исходный текст
Ответ на logging of transaction related events  (Kent Tong <kent@cpttm.org.mo>)
Список pgsql-general
Kent Tong wrote:
>
> Hi,
>
> Is it possible to log events related to transactions, in particular, about
> blocking? For example:
>
>    INFO: transaction 123 is blocked waiting for locked held by transaction
> 456.

8.3 will have a log_lock_waits parameter which will do something like
that.

--
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://postgres.enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +

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

Предыдущее
От: Richard Huxton
Дата:
Сообщение: Re: Coordinating database user accounts with active directory
Следующее
От: Raymond O'Donnell
Дата:
Сообщение: Re: Coordinating database user accounts with active directory