Обсуждение: logging of transaction related events

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.

Thanks!

-----
--
Kent Tong
Wicket tutorials freely available at http://www.agileskills2.org/EWDW
--
View this message in context: http://www.nabble.com/logging-of-transaction-related-events-tf4849017.html#a13873778
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

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. +