Re: idle transactions vs memory

From: Ron <ronljohnsonjr(at)gmail(dot)com>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: idle transactions vs memory
Date: 2020-12-07 02:51:46
Message-ID: 5c110bc3-54c5-ede2-6aea-58b2bd5e7565@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On 12/6/20 8:29 PM, Atul Kumar 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.

Whether or not they occupy RAM or use CPU, idle transactions violate one of
the fundamental rules of database programming: keep transactions short!

--
Angular momentum makes the world go 'round.

In response to

Browse pgsql-admin by date

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