> >> 1) pg_locks ::: need to write trigger... and have high overhead... > > > What do you mean by "write trigger"? > > I'm sure he's imagining that he can create a trigger on pg_locks and > thereby capture lock-related events :-( well that was wht i was thinking.... got it now... i will recompile with LOCK_DEBUG thx Himanshu > > regards, tom lane > __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq