Skip site navigation (1) Skip section navigation (2)

Re: no-arg cluster and locks ...

From: "Adam Rich" <adam(dot)r(at)sbcglobal(dot)net>
To: "'Alvaro Herrera'" <alvherre(at)commandprompt(dot)com>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: no-arg cluster and locks ...
Date: 2008-02-25 03:31:53
Message-ID: 00a001c8775e$f751e630$e5f5b290$ (view raw, whole thread or download thread mbox)
Lists: 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.

In response to

pgsql-general by date

Next:From: danmcbDate: 2008-02-25 04:37:57
Subject: request help forming query
Previous:From: Alvaro HerreraDate: 2008-02-25 02:01:08
Subject: Re: no-arg cluster and locks ...

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group