Re: Does idle sessions will consume more cpu and ram? If yes,how tocontrol them - Mailing list pgsql-general

From Pavel Stehule
Subject Re: Does idle sessions will consume more cpu and ram? If yes,how tocontrol them
Date
Msg-id CAFj8pRC0M8oM=P1wdf54iBMRnbA0PUBy4mDDfrvcJyf6iBaamg@mail.gmail.com
Whole thread Raw
In response to Re: Does idle sessions will consume more cpu and ram? If yes,how tocontrol them  (Ron <ronljohnsonjr@gmail.com>)
Responses Re: Does idle sessions will consume more cpu and ram? If yes,how tocontrol them  (Joshua White <joshua.white@monash.edu>)
List pgsql-general


čt 20. 12. 2018 v 2:41 odesílatel Ron <ronljohnsonjr@gmail.com> napsal:
On 12/19/18 7:27 PM, Michael Paquier wrote:
[snip]
> Each backend stores its own copy of the relation cache, so if you have
> idle connections which have been used for other work in the past then
> the memory of those caches is still around.  Idle connections also have
> a CPU cost in Postgres when building snapshots for example, and their
> entries need to be scanned from a wider array, but usually the relation
> cache bloat is a wider problem.

So it's best to kill connections that have been idle for a while?

sure - one hour idle connection is too old.
 

--
Angular momentum makes the world go 'round.

pgsql-general by date:

Previous
From: Ron
Date:
Subject: Re: Does idle sessions will consume more cpu and ram? If yes,how tocontrol them
Next
From: Joshua White
Date:
Subject: Re: Does idle sessions will consume more cpu and ram? If yes,how tocontrol them