Re: new GUC var: autovacuum_process_all_tables

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Simon Riggs <simon(at)2ndQuadrant(dot)com>
Cc: Pg Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: new GUC var: autovacuum_process_all_tables
Date: 2009-02-05 21:54:56
Message-ID: 20090205215456.GJ3064@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Simon Riggs wrote:
>
> On Thu, 2009-02-05 at 18:25 -0300, Alvaro Herrera wrote:
>
> > So you're not aware that we're doing away with pg_autovacuum for good?
> > It's going to be replaced by reloptions, i.e.
> > ALTER TABLE foo SET (autovacuum_enabled = false);
> >
> > Obviously there's no way to add a "catchall" setting.
>
> Seems like a bad plan then. How do you reconcile those conflicting
> requirements?

I don't see them as conflicting; I see yours as a missing feature,
namely the ability to add tables to an autovacuum "group", which could
have settings attached. Being able to do that is the whole point of
moving settings to reloptions.

--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2009-02-05 22:08:07 Re: new GUC var: autovacuum_process_all_tables
Previous Message Euler Taveira de Oliveira 2009-02-05 21:54:08 Re: new GUC var: autovacuum_process_all_tables