On 07/13/2012 02:42 PM, Santi Camps wrote:
On Fri, Jul 13, 2012 at 7:05 PM, Shane Hathaway <sh...@hathawaymix.org
On 07/12/2012 01:30 PM, Santi Camps wrote:
My specific question is: if I disable pack-gc, can I safety empty
object_ref table and free this space?
Certainly. However, most of the 23 GB probably consists of blobs;
blobs are not shown in the query results you posted.
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
BTW, to prevent a future possible accident, you should also clear
object_refs_added so that RelStorage will know to repopulate object_ref
if you ever decide to re-enable pack-gc. Otherwise, re-enabling pack-gc
could delete too much.
For more information about ZODB, see http://zodb.org/
ZODB-Dev mailing list - ZODB-Dev@zope.org