Thread: autovacuum launcher continues to run after reloading autovacuum=off

autovacuum launcher continues to run after reloading autovacuum=off

From
ITAGAKI Takahiro
Date:
I found that the autovacuum launcher continues to run and spawn workers
after reloading the configuration file with autovacuum = off in CVS HEAD.

What should we do after autovacuum is disabled runtime? I think the
launcher should not spawn any new workers. It can be fixed easily,
but there are some other issues to be discussed:

- Can the launcher exit immediately? or it needs to wait for all worker's exits?
- Should the workers skip the remaining jobs? One difficulty is that workers ingore SIGHUP signals currently.
- Should the workers skip the table being vacuumed then?


Regards,
---
ITAGAKI Takahiro
NTT Open Source Software Center



Re: autovacuum launcher continues to run after reloading autovacuum=off

From
ITAGAKI Takahiro
Date:
I wrote:
> I found that the autovacuum launcher continues to run and spawn workers
> after reloading the configuration file with autovacuum = off in CVS HEAD.

Sorry, I found this issue will be fixed in the 'more autovacuum fixes' patch.
The workers still continues to run, but it would be not a serious problem.

Regards,
---
ITAGAKI Takahiro
NTT Open Source Software Center