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