Re: Parallel heap vacuum - Mailing list pgsql-hackers

From Masahiko Sawada
Subject Re: Parallel heap vacuum
Date
Msg-id CAD21AoCW-YTRf2ToEnhSk2x8BAxmt2iUHbCBdGPTbQhLosR15w@mail.gmail.com
Whole thread Raw
In response to Re: Parallel heap vacuum  (Tomas Vondra <tomas@vondra.me>)
List pgsql-hackers
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



pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: PG 18 relnotes and RC1
Next
From: Masahiko Sawada
Date:
Subject: Re: Proposal: Conflict log history table for Logical Replication