Postgres Pro
Downloads
Home   >   mailing lists

Re: need help on memory allocation - Mailing list pgsql-performance

From Michael Paquier
Subject Re: need help on memory allocation
Date
Msg-id 20180124071559.GA23081@paquier.xyz
Whole thread Raw
In response to Re: need help on memory allocation  (pavan95 <pavan.postgresdba@gmail.com>)
Responses Re: need help on memory allocation
List pgsql-performance
Tree view 
On Tue, Jan 23, 2018 at 10:54:01PM -0700, pavan95 wrote:
> If you are finding some <IDLE> sessions then of course your database is
> perfectly alright. As <IDLE> sessions won't consume any memory.

Those have a cost as well when building transaction snapshots. Too much
of them is no good either, let's not forget that.
--
Michael
Attachment

pgsql-performance by date:

Previous
From: Thomas Kellerer
Date:
Subject: Re: Performance impact of lowering max_files_per_process
Next
From: pavan95
Date:
Subject: Re: need help on memory allocation