On 12/19/2012 02:00 PM, AI Rumman wrote:
Please reply to the list also.
Well the question is how long have those idle transactions been around?
For a good blog on the subject see:
http://www.depesz.com/2008/08/__28/hunting-idle-in-__transactions/
<http://www.depesz.com/2008/08/28/hunting-idle-in-transactions/>
--
Adrian Klaver
adrian.klaver@xxxxxxxxx <mailto:adrian.klaver@xxxxxxxxx>
Thanks for the link. But there is no connection showing 'Idle in
Transaction'.
All are showing only '<IDLE>'.
Hmm, got ahead of myself.
Does pg_locks show anything interesting?
Please hit Reply All so the rest of the list can stay in the loop. More
eyes = faster solution:)
--
Adrian Klaver
adrian.klaver@xxxxxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
