autovacuum: automatically propagate updated parameters

From: Zsolt Parragi <zsolt(dot)parragi(at)percona(dot)com>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: autovacuum: automatically propagate updated parameters
Date: 2026-07-24 08:33:09
Message-ID: CAN4CZFOZtEPwGQ6oa9LvHvN522zEp8h_dW9hHExSh7pVXofoKQ@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

From the documentation:

Parallel workers launched for Parallel Vacuum are using the same cost
delay parameters as the leader worker. If any of these parameters are
changed in the leader worker, it will propagate the new parameter
values to all of its parallel workers.

But in practice, parallel_vacuum_propagate_shared_delay_params was
only called during config reload. Otherwise when the leader adjusted
the parameters, it didn't share them with the other workers.

See the attached patch which adds a test case about this and adds an
additional parallel_vacuum_propagate_shared_delay_params call to the
update logic.

Attachment Content-Type Size
0001-Propagate-rebalanced-cost-limit-to-parallel-vacuum-w.patch application/octet-stream 6.4 KB

Browse pgsql-bugs by date

  From Date Subject
Next Message Zhijie Hou (Fujitsu) 2026-07-24 11:39:25 RE: BUG #19519: REPACK can fail due to missing chunk for toast value
Previous Message Laurenz Albe 2026-07-23 20:28:18 Re: BUG #19573: Unable to install new version 18 (able to install 17)