On 6/13/23 10:20, Konstantin Knizhnik wrote:
The fact that it is flushed out upon reconnection can not help much: what if backends are not going to disconnect?
This is why many connection pools have a maximum connection lifetime which can be configured. So in practice flushing all caches on disconnect helps a lot.
The nice proper solution might very well be adding a maximum cache sizes and replacement but it obviously makes the cache more complex and adds an new GUC. Probably worth it, but flushing caches on disconnect is a simple solution which works well in practice for many but no all workloads.
Andreas
