Jan Wieck <[EMAIL PROTECTED]> writes:However, I have not seen much evidence yet that the vacuum delay alone does that much.
Gaetano and a couple of other people did experiments that seemed to show it was useful. I think we'd want to change the shape of the knob per later suggestions (sleep 10 ms every N blocks, instead of N ms every block) but it did seem that there was useful bang for little buck there.
I thought it was "sleep N ms every M blocks".
Have we seen any numbers? Anything at all? Something that gives us a clue by what factor one has to multiply the total time a "VACUUM ANALYZE" takes, to get what effect in return?
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 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]