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)
_______________________________________________
For more information about ZODB, see http://zodb.org/
ZODB-Dev mailing list - ZODB-Dev@zope.org
https://mail.zope.org/mailman/listinfo/zodb-dev
