Re: autovacuum next steps, take 3 - Mailing list pgsql-hackers

From ITAGAKI Takahiro
Subject Re: autovacuum next steps, take 3
Date
Msg-id 20070313131134.608E.ITAGAKI.TAKAHIRO@oss.ntt.co.jp
Whole thread Raw
In response to Re: autovacuum next steps, take 3  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: autovacuum next steps, take 3
Next
From: ITAGAKI Takahiro
Date:
Subject: Re: Bug: Buffer cache is not scan resistant