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

From Masahiko Sawada
Subject Re: autovacuum: automatically propagate updated parameters
Date
Msg-id CAD21AoD2v1Qn9xCAuTmwro=NQJyL8+N6GT-CBmcTdyQrC5pvkw@mail.gmail.com
Whole thread
In response to Re: autovacuum: automatically propagate updated parameters  (Daniel Gustafsson <daniel@yesql.se>)
Responses Re: autovacuum: automatically propagate updated parameters
Re: autovacuum: automatically propagate updated parameters
List pgsql-bugs
On Mon, Sep 28, 2026 at 9:13 AM Daniel Gustafsson <daniel@yesql.se> wrote:
>
> > On 26 Sep 2026, at 06:37, Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com> wrote:
> > On Fri, Sep 25, 2026 at 5:32 PM Masahiko Sawada <sawada.mshk@gmail.com> wrote:
>
> >> As for the 0001 patch, it looks good to me.
>
> Agreed, +1 pn 0001.
>
> > Please find the attached v4 patches. 0002 remains the same.
>
> Regarding 0002, ISTM that it will be stable but we could also just commit to
> master and hold off on REL_19_STABLE for now.  Once proven it can be back-
> patched even post GA as it is test-only.  That could give us more time while
> reducing the risk of unstable tests this very late in the cycle.

Agreed.

Daniel, are you planning to push the 0001 patch separately from the
tests? I will be attending Postgres Summit US 2026 this week, so I can
push 0001 early next week instead just in case the buildfarm turns red
and requires monitoring.

> comments on 0002:

Aside from these comments, I think we could simplify the tests by
introducing a boolean variable, say, leader_participates that controls
whether the leader participates in parallel index vacuuming. It would
default to true, but we could toggle it off via an injection point.
When set to false, the leader would vacuum parallel-unsafe indexes but
skip parallel-safe ones.

Regards,

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



pgsql-bugs by date:

Previous
From: PG Bug reporting form
Date:
Subject: BUG #19731: `first_value` returns an excluded peer for a nonempty `EXCLUDE TIES` frame
Next
From: PG Bug reporting form
Date:
Subject: BUG #19732: first_value/last_value/nth_value return NULL with EXCLUDE TIES when the current row is outside its f