Re: increased duration of stats_ext tests with -DCLOBBER_CACHE_ALWAYS - Mailing list pgsql-hackers

From Tomas Vondra
Subject Re: increased duration of stats_ext tests with -DCLOBBER_CACHE_ALWAYS
Date
Msg-id 322395e3-664c-4718-82a2-f2f8dec60dbb@vondra.me
Whole thread Raw
In response to Re: increased duration of stats_ext tests with -DCLOBBER_CACHE_ALWAYS  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers

On 12/3/25 19:33, Tom Lane wrote:
> I wrote:
>> Yeah, I can imagine that constantly flushing the cached plan for
>> that plpgsql function would be bad.  Let me see if I can reformulate
>> that test without using a plpgsql function --- right offhand, it's
>> not obvious why a built-in function wouldn't serve the purpose
>> just as well.
> 
> I pushed a change for this.  On my Mac laptop, it brings the time
> for stats_ext with -DCLOBBER_CACHE_ALWAYS down to ~8 minutes, from
> I-didn't-have-the-patience-to-wait-but-it-would-have-been-hours.
> 

Thanks!

> BTW, I noticed that neither avocet nor trilobite seem to have
> 'use_installcheck_parallel' enabled in their BF config files.
> That results in the installcheck steps taking longer than the
> check step, when they should be the same time or shorter.
> You could shave several hours off the animals' runtime by
> enabling that.
> 

Good idea, I enabled that for both animals.


-- 
Tomas Vondra




pgsql-hackers by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: POC: make mxidoff 64 bits
Next
From: Jacob Champion
Date:
Subject: Re: [PATCH] Add enable_copy_program GUC to control COPY PROGRAM