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. #
#================================================== [EMAIL PROTECTED] #
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly