-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
Jan Wieck wrote:
| 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.
No need to be smarty pants too. I know that it can be possible, after all 4 years for a dummy like I'm, are enough to understand that is possible to change some GUC for a given connection. :-)
However I think is annoying to write:
set vacuum_cost_delay = 100; vacuum table <big_huge>; set vacuum_cost_delay = 0; set <whatelse>; vacuum table <night_table>; .... ....
or even better:
psql -c "set vacuum_cost_delay = 100; vacuum analyze;"
and what about the utility vacuumdb ?
If I remember well this is the first command that need to change GUC in order to change behaviour, I don't think we wrote:
set vacuum_mode = full; set vacuum_verbosity = on; vacuum;
Regards Gaetano Mendola
-----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.4 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org
iD8DBQFBGAud7UpzwH2SGd4RAjR0AKDw8XLAI2Lo2uqRauwhWJWwGmwYtgCgmI7u WDZvqwUMzuwXN6Z1qqj91vs= =Wxpz -----END PGP SIGNATURE-----
---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
