Re: VACUUM DELAY - Mailing list pgsql-hackers

From Gaetano Mendola
Subject Re: VACUUM DELAY
Date
Msg-id 4117B230.1050307@bigfoot.com
Whole thread Raw
In response to Re: VACUUM DELAY  (Jan Wieck <JanWieck@Yahoo.com>)
Responses Re: VACUUM DELAY  (Alvaro Herrera <alvherre@dcc.uchile.cl>)
Re: VACUUM DELAY  (Jan Wieck <JanWieck@Yahoo.com>)
List pgsql-hackers
Jan Wieck wrote:

> On 8/9/2004 7:19 AM, Gaetano Mendola wrote:
> 
>> Hi all,
>> I have seen the big debat about to have the delay
>> off or on by default.
>>
>> Why not enable it by default and introduce a new
>> parameter to vacuum command itself ? Something like:
>>
>>
>> VACUUM .... WITH DELAY 100;
> 
> 
> It's not just one parameter to tune here. It is a set of parameters that 
> all together need to be viewed as a whole. The slowdown will be affected 
> by the other parameters as well, so turning the millisecond knob only is 
> not even half of the story.

So the other parameter will inserted in the new sintax too, I think is fundamental
the ability of override this values during the vacuum call:

VACUUM .... WITH DELAY 100 [ .... ];



Regards
Gaetano Mendola





pgsql-hackers by date:

Previous
From: James William Pye
Date:
Subject: Re: SRFs ExecMakeTableFunctionResult
Next
From: James William Pye
Date:
Subject: Re: Postgres development model (was Re: CVS comment)