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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
