Re: idle transactions vs memory

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: Atul Kumar <akumar14871@xxxxxxxxx>
Subject: Re: idle transactions vs memory
From: "David G. Johnston" <david.g.johnston@xxxxxxxxx>
Date: Sun, 6 Dec 2020 22:41:32 -0700
Cc: pgsql-admin <pgsql-admin@xxxxxxxxxxxxxx>
In-reply-to: <CA+ONtZ4qAb8VSpWacOiSTOJ5-y-Pb_uhHUW_kGkO4gDMthb4Sw@mail.gmail.com>
References: <CA+ONtZ7mpJ7W43G19wATC7aipjUWqBDw1_QQdd7CARAvA7DS3w@mail.gmail.com> <10CEA2EF-210C-48F3-AC4C-F035292E6CAD@elevated-dev.com> <CA+ONtZ4qAb8VSpWacOiSTOJ5-y-Pb_uhHUW_kGkO4gDMthb4Sw@mail.gmail.com>

On Sunday, December 6, 2020, Atul Kumar <akumar14871@xxxxxxxxx> 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.

References:
- idle transactions vs memory
  - From: Atul Kumar
- Re: idle transactions vs memory
  - From: Scott Ribe
- Re: idle transactions vs memory
  - From: Atul Kumar

Prev by Date: Re: idle transactions vs memory
Next by Date: Re: idle transactions vs memory
Previous by thread: Re: idle transactions vs memory
Next by thread: Re: idle transactions vs memory
Index(es):
- Date
- Thread

[Index of Archives] [KVM ARM] [KVM ia64] [KVM ppc] [Virtualization Tools] [Spice Development] [Libvirt] [Libvirt Users] [Linux USB Devel] [Linux Audio Users] [Yosemite Questions] [Linux Kernel] [Linux SCSI] [XFree86]

Powered by Linux