Hi<div><br></div><div>I've been using relstorage for years in production environments and it's really amazing, zero big problems. However, I have now some big databases. I'm examining one of them, 23 GB in total, postgresql 8.3 and RelStorage 1.5.1 and I see that biggest objects are objects_ref and it's index:</div>
<div><br></div><div> relname | relpages <br>
-------------------------------------------------+----------<br>
pg_toast_11069817 | 987842<br>
object_ref | 709272<br>
object_ref_pkey | 560284<br>
object_state | 267525</div><div><br></div><div><p>select count(*) from object_ref;<br>
count <br>
-----------<br>
111224549</p>
<p>select count(*) from object_refs_added;<br>
count <br>
--------<br>
216341</p>
<p>select count(*) from object_state;<br>
count <br>
---------<br>
2545303</p><p>Data is consistent, no references to unexisting or empty transactions. So, information to garbage collection seems to be using a lot of space.</p><div>My specific question is: if I disable pack-gc, can I safety empty object_ref table and free this space?</div>
<div><br></div><div>Thanks in advance</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>
</div>