Re: Does idle sessions will consume more cpu and ram? If yes,how to control them

čt 20. 12. 2018 v 2:41 odesílatel Ron <ronljohnsonjr(at)gmail(dot)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.
>
>