Re: VACUUM DELAY

Поиск
Список
Период
Сортировка
От Gaetano Mendola
Тема Re: VACUUM DELAY
Дата
Msg-id 4117B230.1050307@bigfoot.com
обсуждение исходный текст
Ответ на Re: VACUUM DELAY  (Jan Wieck <JanWieck@Yahoo.com>)
Ответы Re: VACUUM DELAY  (Alvaro Herrera <alvherre@dcc.uchile.cl>)
Re: VACUUM DELAY  (Jan Wieck <JanWieck@Yahoo.com>)
Список 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 по дате отправления:

Предыдущее
От: James William Pye
Дата:
Сообщение: Re: SRFs ExecMakeTableFunctionResult
Следующее
От: James William Pye
Дата:
Сообщение: Re: Postgres development model (was Re: CVS comment)