autovacuum launcher continues to run after reloading autovacuum=off

From: ITAGAKI Takahiro <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp>
To: pgsql-hackers(at)postgresql(dot)org
Subject: autovacuum launcher continues to run after reloading autovacuum=off
Date: 2007-06-21 04:56:56
Message-ID: 20070621133028.6E70.ITAGAKI.TAKAHIRO@oss.ntt.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce McAlister 2007-06-21 07:36:35 AutoVacuum Behaviour Question
Previous Message ITAGAKI Takahiro 2007-06-21 03:27:22 Re: DROP TABLE and autovacuum