Re: autovacuum next steps, take 3

Поиск
Список
Период
Сортировка
От ITAGAKI Takahiro
Тема Re: autovacuum next steps, take 3
Дата
Msg-id 20070313131134.608E.ITAGAKI.TAKAHIRO@oss.ntt.co.jp
обсуждение исходный текст
Ответ на Re: autovacuum next steps, take 3  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Tom Lane <tgl@sss.pgh.pa.us> wrote:

> Who said anything about external schedulers?  I remind you that this is
> AUTOvacuum.  If you want to implement manual scheduling you can still
> use plain 'ol vacuum commands.

I think we can split autovacuum into two (or more?) functions:
task gatherers and task workers. We don't have to bother with
the monolithic style of current autovacuum.


Galy said:
> The task queue might be filled by dedicated task-gathering-worker or it
> might be filled by *external task gatherer*.

Alvaro said:
> The idea of an external task gatherer is an interesting one which I
> think would make sense to implement in the future.  I think it is not
> very difficult to implement once the proposal we're currently discussing
> is done

I said:
> Though we can use a completely separated autovacuum daemon like as
> contrib/pg_autovacuum of 8.0, but I think it is good for us to share
> some of the codes between a built-in scheduler and external ones.

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




В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: autovacuum next steps, take 3
Следующее
От: ITAGAKI Takahiro
Дата:
Сообщение: Re: Bug: Buffer cache is not scan resistant