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? -- Angular momentum makes the world go 'round.
