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

From Ron
Subject Re: idle transactions vs memory
Date
Msg-id 5c110bc3-54c5-ede2-6aea-58b2bd5e7565@gmail.com
Whole thread Raw
In response to idle transactions vs memory  (Atul Kumar <akumar14871@gmail.com>)
List 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.



pgsql-admin by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: idle transactions vs memory
Next
From: Scott Ribe
Date:
Subject: Re: idle transactions vs memory