Thanks for the tip!<div><br></div><div>--</div><div>Noe<br><br><div class="gmail_quote">2010/10/20 David Blewett <span dir="ltr"><<a href="mailto:david@dawninglight.net">david@dawninglight.net</a>></span><br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
<div class="im">On Tue, Oct 19, 2010 at 1:05 AM, Noe Misael Nieto Arroyo<br>
<<a href="mailto:noe@iservices.com.mx">noe@iservices.com.mx</a>> wrote:<br>
> And if yes, What kind of VACUUM is good? FULL, CLUSTER?<br>
<br>
</div>VACUUM FULL is almost never a good idea; autovac should be sufficient<br>
for most needs, and can be tweaked to meet particular performance<br>
issues. I have had very good results doing a CLUSTER after an initial<br>
zodbconvert run to significantly reduce the size of the database. I<br>
highly recommend doing CLUSTER after any large data loads.<br>
<font color="#888888"><br>
David Blewett<br>
</font></blockquote></div><br></div>