Re: autovacuum: automatically propagate updated parameters - Mailing list pgsql-bugs

From Bharath Rupireddy
Subject Re: autovacuum: automatically propagate updated parameters
Date
Msg-id CALj2ACVnxudCDbi1DaxpkR=jLC4Ff01msAgL_w8W=P2EOeN3Aw@mail.gmail.com
Whole thread
In response to Re: autovacuum: automatically propagate updated parameters  (Masahiko Sawada <sawada.mshk@gmail.com>)
Responses Re: autovacuum: automatically propagate updated parameters
List pgsql-bugs
Hi,

On Fri, Sep 25, 2026 at 5:32 PM Masahiko Sawada <sawada.mshk@gmail.com> wrote:
>
> And it happens only when the number of workers sharing the cost limit
> changes. So I agree that it's acceptable, and given we're close to
> RC1, I'm fine with the SetLatch() approach.
>
> As for the 0001 patch, it looks good to me. I have one minor comment,
> though it's a matter of personal preference:

Thanks for reviewing it.

> +void
> +parallel_vacuum_refresh_cost_params(void)
>
> The second paragraph explains how this function is called. Since what
> the function does, as well as its name, is not specific to that wait,
> I guess it's better to explain it on the caller side, and the comment
> newly added in WaitForParallelWorkersToFinish() already explains a
> similar thing. Then the function comment can focus on what the
> function does and its side effects, such as reloading the
> configuration file. For example:
>
>   /*
>    * Reload the configuration file if requested, and refresh the cost-based
>    * delay parameters of an autovacuum worker running a parallel vacuum
>    * (leader), propagating any change to its parallel workers.
>    */

Agreed.

Please find the attached v4 patches. 0002 remains the same.

--
Bharath Rupireddy
Amazon Web Services: https://aws.amazon.com

Attachment

pgsql-bugs by date:

Previous
From: Masahiko Sawada
Date:
Subject: Re: autovacuum: automatically propagate updated parameters
Next
From: PG Bug reporting form
Date:
Subject: BUG #19721: json_value with DEFAULT ON ERROR returns inconsistent results for NULL input in materialized CTE