On Fri, Jul 13, 2012 at 7:05 PM, Shane Hathaway <span dir="ltr"><<a href="mailto:shane@hathawaymix.org" target="_blank">shane@hathawaymix.org</a>></span> wrote:<br><div class="gmail_quote"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div class="im">On 07/12/2012 01:30 PM, Santi Camps wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
My specific question is: if I disable pack-gc, can I safety empty<br>
object_ref table and free this space?<br>
</blockquote>
<br></div>
Certainly. However, most of the 23 GB probably consists of blobs; blobs are not shown in the query results you posted.<span class="HOEnZb"><font color="#888888"><br>
<br>
Shane<br>
</font></span></blockquote></div><br>Thanks for your answer. I haven't blobs inside ZODB, but truncating object_ref table has shrink the database to 12GB Great improvement, I prefer that config because in this application deletions are rare<br clear="all">
<div><br></div><div>Thanks</div>-- <br>Santi Camps <br>KMKey hacker (<a href="http://www.kmkey.com">http://www.kmkey.com</a>)<br>Earcon S.L. (<a href="http://www.earcon.com">http://www.earcon.com</a>)<br><br><br>