From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
---|---|
To: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
Cc: | ITAGAKI Takahiro <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp>, Patches <pgsql-patches(at)postgresql(dot)org> |
Subject: | Re: autovacuum multiworkers, patch 5 |
Date: | 2007-04-05 02:47:45 |
Message-ID: | 20070405024745.GN19251@alvh.no-ip.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-patches |
Joshua D. Drake wrote:
> Alvaro Herrera wrote:
> >ITAGAKI Takahiro wrote:
> >>Alvaro Herrera <alvherre(at)commandprompt(dot)com> wrote:
> >>
> >>>Here is the autovacuum patch I am currently working with. This is
> >>>basically the same as the previous patch; I have tweaked the database
> >>>list management so that after a change in databases (say a new database
> >>>is created or a database is dropped), the list is recomputed to account
> >>>for the change, keeping the ordering of the previous list.
> >>I'm interested in your multiworkers autovacuum proposal.
> >>
> >>I'm researching the impact of multiworkers with
> >>autovacuum_vacuum_cost_limit.
> >>Autovacuum will consume server resources up to autovacuum_max_workers
> >>times
> >>as many as before. I think we might need to change the semantics of
> >>autovacuum_vacuum_cost_limit when we have multiworkers.
> >
> >Yes, that's correct. Per previous discussion, what I actually wanted to
> >do was to create a GUC setting to simplify the whole thing, something
> >like "autovacuum_max_mb_per_second" or "autovacuum_max_io_per_second".
> >Then, have each worker use up to (max_per_second/active workers) as much
> >IO resources. This way, the maximum use of IO resources by vacuum can
> >be easily determined and limited by the DBA; certainly much simpler than
> >the vacuum cost limiting feature.
>
> +1
One thing I forgot to mention is that this is unlikely to be implemented
in 8.3.
--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2007-04-05 03:08:15 | Re: CREATE TABLE LIKE INCLUDING INDEXES support |
Previous Message | Tatsuo Ishii | 2007-04-05 02:15:37 | Re: Optimized pgbench for 8.3 |
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2007-04-05 03:08:15 | Re: CREATE TABLE LIKE INCLUDING INDEXES support |
Previous Message | Tatsuo Ishii | 2007-04-05 02:15:37 | Re: Optimized pgbench for 8.3 |