Re: VACUUM DELAY

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