[ZODB-Dev] Question about relstorage and pack-gc

Santi Camps scamps at earcon.com
Thu Jul 12 19:30:10 UTC 2012


Hi

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:

                     relname                     | relpages
-------------------------------------------------+----------
 pg_toast_11069817                               |   987842
 object_ref                                      |   709272
 object_ref_pkey                                 |   560284
 object_state                                    |   267525

select count(*) from object_ref;
   count
-----------
 111224549

select count(*) from object_refs_added;
 count
--------
 216341

select count(*) from object_state;
  count
---------
 2545303

Data is consistent, no references to unexisting or empty transactions.
  So, information to garbage collection seems to be using a lot of space.
My specific question is: if I disable pack-gc, can I safety empty
object_ref table and free this space?

Thanks in advance
-- 
Santi Camps
KMKey hacker (http://www.kmkey.com)
Earcon S.L. (http://www.earcon.com)
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.zope.org/pipermail/zodb-dev/attachments/20120712/8cf29c16/attachment.html>


More information about the ZODB-Dev mailing list