|
On 2/6/2013 1:28 AM, Anoop K wrote:
you need to track down what resources are being locked by those processes, by joining pg_stat_activity against pg_locks and.... (been awhile, I forget the magic join query that gives you useful info here) IDLE in Transaction means that connection did a BEGIN; but isn't executing any commands at all at present and is just sitting there. This should never happen, and is generally a sign of buggy application software, or poorly designed ORM or something. -- john r pierce 37N 122W somewhere on the middle of the left coast |
