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