Re: [HACKERS] autovacuum launcher continues to run after reloading autovacuum=off
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 ---(end of broadcast)--- TIP 6: explain analyze is your friend
[HACKERS] autovacuum launcher continues to run after reloading autovacuum=off
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 ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org