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