Bruce Momjian a écrit :
On Thu, Aug 26, 2021 at 03:38:23PM +0200, Daniel Gustafsson wrote:
On 26 Aug 2021, at 15:09, Bruce Momjian<br...@momjian.us> wrote:
On Thu, Aug 26, 2021 at 03:24:33PM +0800, Julien Rouhaud wrote:
.. I still think that
changing bgworker_should_start_now() is a better option.
I am not sure. We have a lot of pg_upgrade code that turns off things
like autovacuum and that has worked fine:
True, but there are also conditionals on IsBinaryUpgrade for starting the
autovacuum launcher in the postmaster, so there is some precedent.
Oh, I was not aware of that.
If I understand correctly, autovacuum is turned off by pg_upgrade code
only if the old cluster does not support the -b flag (prior to 9.1
apparently). Otherwise, this is indeed handled by IsBinaryUpgrade.
