Re: VACUUM DELAY - Mailing list pgsql-hackers

From Jan Wieck
Subject Re: VACUUM DELAY
Date
Msg-id 41179A10.1030304@Yahoo.com
Whole thread Raw
In response to VACUUM DELAY  (Gaetano Mendola <mendola@bigfoot.com>)
Responses Re: VACUUM DELAY  (Gaetano Mendola <mendola@bigfoot.com>)
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: Analyze using savepoints?
Next
From: Robert Treat
Date:
Subject: lpthread errors while compiling 8.0beta