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