Re: VACUUM DELAY

On 8/9/2004 1:19 PM, Gaetano Mendola wrote:

> 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 [ .... ];

You can do it right now.

set vacuum_cost_delay = 100;
vacuum analyze;

No need to panic.


Jan

-- 
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck@Yahoo.com #