Postgres Pro
Downloads
Home   >   mailing lists

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

From David G. Johnston
Subject Re: idle transactions vs memory
Date
Msg-id CAKFQuwbP5XxNYnedk2vq3V7BGesHQdhf9G5F+6EJ-oMvQAwHgQ@mail.gmail.com
Whole thread Raw
In response to Re: idle transactions vs memory  (Atul Kumar <akumar14871@gmail.com>)
List pgsql-admin
Tree view
On Sunday, December 6, 2020, Atul Kumar <akumar14871@gmail.com> wrote:
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 ?


Sessions and transactions are two different things.

Yes, idle sessions consume a non-zero amount of resources.

David J.

pgsql-admin by date:

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