[ZODB-Dev] Optimizing RelStorage Packing for large DBs

Jan-Wijbrand Kolman janwijbrand at gmail.com
Mon Nov 18 14:43:00 CET 2013


On 11/18/13 12:19 PM, Jim Fulton wrote:
> On Fri, Nov 15, 2013 at 8:01 PM, Jens W. Klein <jens at bluedynamics.com> wrote:
>> I started a new packing script for Relstorage (history free, postgresql). It
>> is based on incoming reference counting.
>
> Did you look at zc.zodbdgc?  I think it implements something very close to
> what you're proposing.  It's been in production for a few years now at ZC.
>
> Not sure if it would need to be updated for relstorage.

AFAICT it does not work against a relstorage backend. Or at least I 
think to understand that from:

http://www.zodb.org/en/latest/documentation/articles/multi-zodb-gc.html

[...This documentation does not apply to RelStorage which has the same 
features built-in, but accessible in different ways. Look at the options 
for the zodbpack script. The –prepack option creates a table containing 
the same information as we are creating in the reference database[...]


regards, jw





More information about the ZODB-Dev mailing list