Decibel! wrote: > > I don't have any immediate ideas for improvement either, but we > > certainly shouldn't consider this a totally solved problem. > > Something I always find myself wanting when debugging locking issues > is what's in pg_locks. Could we save that information somewhere when > we detect a deadlock? In a real table would be nice, but I'd settle > for just dumping it to a file somewhere. Or maybe into the logs.
That option will be in 8.4, logging deadlock information. -- Bruce Momjian <[EMAIL PROTECTED]> http://momjian.us EnterpriseDB http://enterprisedb.com + If your life is a hard drive, Christ can be your backup. + -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
