autovacuum launcher continues to run after reloading autovacuum=off - Mailing list pgsql-hackers

From ITAGAKI Takahiro
Subject autovacuum launcher continues to run after reloading autovacuum=off
Date
Msg-id 20070621133028.6E70.ITAGAKI.TAKAHIRO@oss.ntt.co.jp
Whole thread Raw
Responses Re: autovacuum launcher continues to run after reloading autovacuum=off  (ITAGAKI Takahiro <itagaki.takahiro@oss.ntt.co.jp>)
List pgsql-hackers
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



pgsql-hackers by date:

Previous
From: ITAGAKI Takahiro
Date:
Subject: Re: DROP TABLE and autovacuum
Next
From: Michael Paesold
Date:
Subject: Re: GUC time unit spelling a bit inconsistent