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@gmail.com <mailto:adrian.klaver@gmail.com>
>
>
> 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@gmail.com