Re: idle transactions vs memory - Mailing list pgsql-admin

From David G. Johnston
Subject Re: idle transactions vs memory
Date
Msg-id CAKFQuwY0XCtS5ZV=bTncsRHqfPMh7JW7exBFrxhkAwFGvmHikw@mail.gmail.com
Whole thread Raw
In response to idle transactions vs memory  (Atul Kumar <akumar14871@gmail.com>)
List pgsql-admin
On Sunday, December 6, 2020, Atul Kumar <akumar14871@gmail.com> wrote:
Hi,

I have a basic query that do idle transactions (idle more than 5
minutes) occupy system memory (RAM) or CPU usage ?


Please help me.


Help you what?  Queries don’t idle so I don’t even know what you are looking at.  But, generally, long-lived idle in transaction session are bad for many reasons and you should fix your application code to avoid them.

David J.

pgsql-admin by date:

Previous
From: Atul Kumar
Date:
Subject: idle transactions vs memory
Next
From: Ron
Date:
Subject: Re: idle transactions vs memory