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

From Zsolt Parragi
Subject autovacuum: automatically propagate updated parameters
Date
Msg-id CAN4CZFOZtEPwGQ6oa9LvHvN522zEp8h_dW9hHExSh7pVXofoKQ@mail.gmail.com
Whole thread
List 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

pgsql-bugs by date:

Previous
From: Thom Brown
Date:
Subject: Re: BUG #19575: Enhancement for Redundant DISTINCT in set-operation branches
Next
From: "Zhijie Hou (Fujitsu)"
Date:
Subject: RE: BUG #19519: REPACK can fail due to missing chunk for toast value