[ZODB-Dev] Relstorage and over growing database.

[Martijn Pieters]

On Mon, Nov 11, 2013 at 9:24 PM, Daniel Widerin <daniel at widerin.net> wrote:

> Anyone experienced similar problems packing large relstorage databases?
> The graph traversal takes a really long time. maybe we can improve that
> by storing additional information in the relational database?
>

You should (at least initially) pack *without* GC (set pack-gc true to
false); I packed a humongous RelStorage-backed database before, and packed
to earlier dates in the past first to minimize the amount of data removed
in a single transaction.

Only when we were down to a reasonable size database did we enable garbage
collection.

-- 
Martijn Pieters
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.zope.org/pipermail/zodb-dev/attachments/20131112/9c9d5da5/attachment.html>