Re: pg_xlog is getting bigger

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