Re: idle transactions vs memory

From: Atul Kumar <akumar14871(at)gmail(dot)com>
To: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: idle transactions vs memory
Date: 2020-12-07 05:34:03
Message-ID: CA+ONtZ4qAb8VSpWacOiSTOJ5-y-Pb_uhHUW_kGkO4gDMthb4Sw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

The transactions state is 'idle' from more than 15 minutes, so my
question is that are they occupying any amount of RAM?

are these 'idle' transactions are using CPU ?

Please help me.

Regards,
Atul

On 12/7/20, Scott Ribe <scott_ribe(at)elevated-dev(dot)com> wrote:
>> On Dec 6, 2020, at 7:29 PM, Atul Kumar <akumar14871(at)gmail(dot)com> wrote:
>>
>> I have a basic query that do idle transactions (idle more than 5
>> minutes) occupy system memory (RAM) or CPU usage ?
>
> Actual idle transaction? Or just idle connections not currently in
> transactions?
>
>

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message David G. Johnston 2020-12-07 05:41:32 Re: idle transactions vs memory
Previous Message Scott Ribe 2020-12-07 02:58:07 Re: idle transactions vs memory