Skip site navigation (1) Skip section navigation (2)

Re: Interface for pg_autovacuum

From: "Jim Nasby" <jim(dot)nasby(at)enterprisedb(dot)com>
To: "Andrew Dunstan" <andrew(at)dunslane(dot)net>
Cc: "Simon Riggs" <simon(at)2ndquadrant(dot)com>,"Dave Page" <dpage(at)postgresql(dot)org>,"Florian G(dot) Pflug" <fgp(at)phlo(dot)org>,"PGSQL Hackers" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Interface for pg_autovacuum
Date: 2006-12-22 05:16:56
Message-ID: EC196807-8D20-4290-9684-1A33F1FF2992@enterprisedb.com (view raw or flat)
Thread:
Lists: pgsql-hackers
On Dec 21, 2006, at 1:28 PM, Andrew Dunstan wrote:
> Jim Nasby wrote:
>> How about...
>>
>> ALTER TABLE ...
>> ALTER AUTOVACUUM [ THRESHOLD | SCALE | COST DELAY | COST LIMIT ]
>> ALTER AUTOANALYZE [ THRESHOLD | SCALE ]
>
> Given these remarks from Tom:
>
>> Where we are currently at is experimenting to find
>> out what autovacuum's control knobs ought to be.  The catalog  
>> table was
>> a suitably low-effort way to expose a first cut at the knobs.
>
> doesn't making language level changes seem more than somewhat  
> premature? Or have we finished experimenting?

Well, the only one I could possibly see removing would be threshold,  
but the reality is that these parameters have been kicking around  
since 7.4, so...

But I do like Richard Huxton's suggestion for syntax... that looks a  
lot more flexible than what I proposed.

The only other thought that comes to mind is that such syntax will  
make it a *lot* more verbose to set all the options for a table. But  
I don't know how often people feel the need to set *all* of them at  
once... Still, it might be worth continuing to support people poking  
values directly into the table; I just don't think we want to make  
that the official interface.
--
Jim Nasby                               jim(dot)nasby(at)enterprisedb(dot)com
EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)




In response to

Responses

pgsql-hackers by date

Next:From: Tom LaneDate: 2006-12-22 06:15:07
Subject: Re: Interface for pg_autovacuum
Previous:From: Guido BarosioDate: 2006-12-22 04:29:06
Subject: Re: Companies Contributing to Open Source

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group