Re: Parallel heap vacuum

On Wed, Sep 17, 2025 at 5:24 PM Tomas Vondra <tomas@vondra.me> wrote:
>
>
>
> On 9/18/25 01:18, Masahiko Sawada wrote:
> > For your information, while the implementation itself is relatively
> > straightforward, we're still facing one unresolved issue; the system
> > doesn't support reloading the configuration file during parallel mode,
> > but it is necessary for autovacuum to update vacuum cost delay
> > parameters[2].
> >
>
> Hmmm, that's annoying :-(
>
> If it happens only for max_stack_depth (when setting it based on
> environment) maybe we could simply skip that when in parallel mode? But
> it's ugly, and we probably will have the same issue for any other
> GUC_ALLOW_IN_PARALLEL option in a file ...

We have the same issue for all non-GUC_ALLOW_IN_PARALLEL parameters.

Regards,

--
Masahiko Sawada
Amazon Web Services: https://aws.amazon.com