Re: no-arg cluster and locks ... - Mailing list pgsql-general

From Adam Rich
Subject Re: no-arg cluster and locks ...
Date
Msg-id 00a001c8775e$f751e630$e5f5b290$@r@sbcglobal.net
Whole thread Raw
In response to Re: no-arg cluster and locks ...  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-general
> Can you provide more details?  pg_locks, pg_stat_activity, the deadlock
> message?
>
> (Hmm, it would be helpful if the deadlock checker were to save the
> pg_locks contents and perhaps pg_stat_activity in a file, whenever a
> deadlock is detected.)

Great idea!  As somebody who's spent hours tracking down deadlocks
recently, I'd love to have a configurable deadlocks.log file capability.




pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: no-arg cluster and locks ...
Next
From: danmcb
Date:
Subject: request help forming query