čt 20. 12. 2018 v 2:41 odesílatel Ron <ronljohnso...@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. > >
