On Wed, Nov 02, 2005 at 07:12:36PM -0500, Tom Lane wrote: > Bruce Momjian <pgman@xxxxxxxxxxxxxxxx> writes: > > Jim C. Nasby wrote: > >> Would it be feasable to have the lock manager spew out info about lock > >> aquisition and release? Not only would it make getting this information > >> easy, but I suspect it could be a useful debugging tool. > > > Something like log_locks? That would be valuable. > > A moment's thought would suggest that the output would be too voluminous > to be of any use whatever to ordinary users. The capability already > exists at the developer level (see LOCK_DEBUG). Ok, so I guess what we really need is just a docs TODO that mentions LOCK_DEBUG. -- Jim C. Nasby, Sr. Engineering Consultant jnasby@xxxxxxxxxxxxx Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461 ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
