Hi,
On 2021-05-10 14:06:16 -0400, Tom Lane wrote:
> Hm. But constantly flushing the caches should mean that they're never
> populated with very many entries at one time, which ought to forestall
> that, at least to some extent.
That's probably true...
> I wonder if there's anything we could do to make ResetCatalogCache
> faster? It wouldn't help much for normal execution of course,
> but it might do something to bring CCA testing time down out of
> the stratosphere.
We could make the hashtables shrink, not just grow...
There's also the issue that most people, I assume, run CCA tests with -O0. In
a quick test that does make a big difference in e.g. ResetCatalogCache(). I
just added a function specific annotation to optimize just that function and
the overall time in my test shrank 10% or so.
Greetings,
Andres Freund