On Wednesday 20 August 2008 Uwe Kiewel wrote: > Is there a way to estimate the running time of OPTIMIZE?
That depends on so many parameters that it won't be easy to guess. Best is: give it a try, first ANALYZE and then OPTIMIZE, probably on a weekend ;-) I use postgres, it's very different but: A "vacuum full analyze" on a DB of 16GB lasts about 2,75h here, but that is for the full DB. mfg zmi -- // Michael Monnerie, Ing.BSc ----- http://it-management.at // Tel: 0660 / 415 65 31 .network.your.ideas. // PGP Key: "curl -s http://zmi.at/zmi.asc | gpg --import" // Fingerprint: AC19 F9D5 36ED CD8A EF38 500E CE14 91F7 1C12 09B4 // Keyserver: www.keyserver.net Key-ID: 1C1209B4
signature.asc
Description: This is a digitally signed message part.
_______________________________________________ DBmail mailing list [email protected] https://mailman.fastxs.nl/mailman/listinfo/dbmail
