> > 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 <bruce(at)momjian(dot)us> http://momjian.us
+ If your life is a hard drive, Christ can be your backup. +
In response to
pgsql-hackers by date
|Next:||From: Andrew Dunstan||Date: 2008-04-03 00:15:49|
|Subject: Re: modules|
|Previous:||From: Ron Mayer||Date: 2008-04-02 23:41:16|