Re: Reducing opr_sanity test's runtime under CLOBBER_CACHE_ALWAYS

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Reducing opr_sanity test's runtime under CLOBBER_CACHE_ALWAYS
Дата
Msg-id 707127.1620671885@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Reducing opr_sanity test's runtime under CLOBBER_CACHE_ALWAYS  (Andres Freund <andres@anarazel.de>)
Список pgsql-hackers
Andres Freund <andres@anarazel.de> writes:
> On 2021-05-10 14:06:16 -0400, Tom Lane wrote:
>> 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...

Maybe ...

> 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.

If they do I think they're nuts ;-).  CCA is slow enough already without
hobbling it.

hyrax appears to use the usual -O2, as does/did avocet.  Not sure
if we have any other CCA buildfarm members right now.

            regards, tom lane



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Another modest proposal for reducing CLOBBER_CACHE_ALWAYS runtime
Следующее
От: John Naylor
Дата:
Сообщение: Re: PG 14 release notes, first draft