[ZODB-Dev] pack script for RelStorage

[Eric Brun]

Hi,

My pack take 2 days !
And my db have the same size as before start packing :-(

I don't have time for test with log , sorry.
We have a problem with huge Plone site that is very slow.
With RelStorage , we hoped a bit fix this.


Have you experience of RelStorage on huge DB ?


Now I test it with Postgresql 8.1 and pgpool2.
What is the best pratice in the domain (config, clusering ...)?


Thanks for your reply

Cheers

Eric

Le 29 mars 08 à 23:20, Shane Hathaway a écrit :

> Eric Brun wrote:
>> Hi all,
>> I had convert a FileStorage (Data.fs) in to a RelStorage :  
>> Postgresql  8.1, psycopg2, Zope 2.9.8
>> , Python 2.4.5, Plone 2.1 + FileSystemStorage
>> Zope 2.9.8 have ZODB 3.6.3 version but patch for 3.7.1 run ...
>> I have poor performance like FileStorage perhaps more bad
>> My base have size of 5,5 Go. When I try to pack with RelStorage,  
>> it's  very slow
>> , I launch it for 15 hours without success yet.
>
> That's too long, I agree.  I have just committed to Subversion a  
> change that makes RelStorage log diagnostic info during packing.   
> Could you try it out and send me the relevant portion log?  Before  
> you do it, please enable debug-level logging in zope.conf by setting  
> "level debug" in the <eventlog> section.
>
> You could also try setting the "pack-gc no" option in the  
> <relstorage> section.
>
> Shane
>
> _______________________________________________
> For more information about ZODB, see the ZODB Wiki:
> http://www.zope.org/Wikis/ZODB/
>
> ZODB-Dev mailing list  -  ZODB-Dev at zope.org
> http://mail.zope.org/mailman/listinfo/zodb-dev