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@xxxxxxxxxx> http://momjian.us EnterpriseDB http://postgres.enterprisedb.com + If your life is a hard drive, Christ can be your backup. + ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
