On 2/10/2013 10:25 PM, Anoop K wrote:
> Yes, we do that.
well, you need to figure out which connection isn't doing that, as one
of them is leaving a long running transaction pending.
as I said, join pg_stat_activity.pid with pg_locks and whatever to find
out what tables its locking on.
try these
http://wiki.postgresql.org/wiki/Lock_Monitoring
--
john r pierce 37N 122W
somewhere on the middle of the left coast