Re: VACUUM DELAY

Поиск
Список
Период
Сортировка
От Jan Wieck
Тема Re: VACUUM DELAY
Дата
Msg-id 41179A10.1030304@Yahoo.com
обсуждение исходный текст
Ответ на VACUUM DELAY  (Gaetano Mendola <mendola@bigfoot.com>)
Ответы Re: VACUUM DELAY  (Gaetano Mendola <mendola@bigfoot.com>)
Список pgsql-hackers
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.

Setting the delay to zero simply disables the whole feature at runtime. 
That is why this discussion was using the delay parameter as a synonym 
for enabling/disabling the feature by default.


Jan

> 
> 
> this will permit to change easilly the delay in the maintainance
> scripts.
> 
> 
> 
> Regards
> Gaetano Mendola
> 
> 
> 
> 
> 
> 
> 
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org


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


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Analyze using savepoints?
Следующее
От: Robert Treat
Дата:
Сообщение: lpthread errors while compiling 8.0beta