Re: Interface for pg_autovacuum - Mailing list pgsql-hackers

From Jim Nasby
Subject Re: Interface for pg_autovacuum
Date
Msg-id 7C4D872D-7172-40AA-8104-A5AE4241048E@enterprisedb.com
Whole thread Raw
In response to Re: Interface for pg_autovacuum  ("Simon Riggs" <simon@2ndquadrant.com>)
Responses Re: Interface for pg_autovacuum
Re: Interface for pg_autovacuum
List pgsql-hackers
How about...

ALTER TABLE ...
ALTER AUTOVACUUM [ THRESHOLD | SCALE | COST DELAY | COST LIMIT ]
ALTER AUTOANALYZE [ THRESHOLD | SCALE ]

... or would that create a whole bunch of reserved words?

On Dec 21, 2006, at 10:04 AM, Simon Riggs wrote:

> On Wed, 2006-12-20 at 09:47 -0500, Jim Nasby wrote:
>
>> On the other hand, this would be the only part of the system where
>> the official interface/API is a system catalog table. Do we really
>> want to expose the internal representation of something as our API?
>> That doesn't seem wise to me...
>
> Define and agree the API (the hard bit) and I'll code it (the easy  
> bit).
>
> We may as well have something on the table, even if it changes later.
>
> Dave: How does PgAdmin handle setting table-specific autovacuum
> parameters? (Does it?)
>
> -- 
>   Simon Riggs
>   EnterpriseDB   http://www.enterprisedb.com
>
>
>
> ---------------------------(end of  
> broadcast)---------------------------
> TIP 7: You can help support the PostgreSQL project by donating at
>
>                 http://www.postgresql.org/about/donate
>

--
Jim Nasby                               jim.nasby@enterprisedb.com
EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)





pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: column ordering, was Re: [PATCHES] Enums patch v2
Next
From: Gregory Stark
Date:
Subject: Re: Interface for pg_autovacuum