Re: [ZODB-Dev] RelStorage and PostgreSQL's VACUUM
Thanks for the tip! -- Noe 2010/10/20 David Blewett > On Tue, Oct 19, 2010 at 1:05 AM, Noe Misael Nieto Arroyo > wrote: > > And if yes, What kind of VACUUM is good? FULL, CLUSTER? > > VACUUM FULL is almost never a good idea; autovac should be sufficient > for most needs, and can be tweaked to meet particular performance > issues. I have had very good results doing a CLUSTER after an initial > zodbconvert run to significantly reduce the size of the database. I > highly recommend doing CLUSTER after any large data loads. > > David Blewett > ___ For more information about ZODB, see the ZODB Wiki: http://www.zope.org/Wikis/ZODB/ ZODB-Dev mailing list - ZODB-Dev@zope.org https://mail.zope.org/mailman/listinfo/zodb-dev
Re: [ZODB-Dev] Status of gocept.zeoraid
On 10/20/2010 09:46 PM, Christian Theune wrote: > On 10/20/2010 07:11 PM, Chris Withers wrote: >> On 20/10/2010 17:03, Sylvain Viollon wrote: >>> One of my customers would like to use gocept.zeoraid in production. >>> So him, and I have some questions: >>> >>> - Is it stable enough to be used in production ? >> >> No. > > Ack. It's called beta. Then again I should add that I did think it's OK to go forward with caution, but that didn't help. :/ Christian -- Christian Theune · c...@gocept.com gocept gmbh & co. kg · forsterstraße 29 · 06112 halle (saale) · germany http://gocept.com · tel +49 345 1229889 0 · fax +49 345 1229889 1 Zope and Plone consulting and development ___ For more information about ZODB, see the ZODB Wiki: http://www.zope.org/Wikis/ZODB/ ZODB-Dev mailing list - ZODB-Dev@zope.org https://mail.zope.org/mailman/listinfo/zodb-dev
Re: [ZODB-Dev] Status of gocept.zeoraid
On 10/20/2010 07:11 PM, Chris Withers wrote: > On 20/10/2010 17:03, Sylvain Viollon wrote: >> One of my customers would like to use gocept.zeoraid in production. >> So him, and I have some questions: >> >> - Is it stable enough to be used in production ? > > No. Ack. It's called beta. I do need people interested in using it to try it out *seriously*, though. Chris hit quite a wall even when testing it for a while. I've got some data from that but the lesson is: don't think it's ready for (your) production if you haven't run it in (your) production successfully. >> - Does it bring speed improvements over regular ZEO setup (I don't >> think so) ? > > No. It is currently 5 times slower when tested with zodbshootout. And there will likely never will be speed improvements over regular ZEO. I was a bit shocked when I looked at the actual slowness, but then again, I didn't think about performance at all. (In standalone mode there is a slight chance that you can load read-requests off to multiple backend servers. Haven't tried it, though. And it won't be available in co-op mode. >> - Does it work with blobs ? I will have a blob directory shared >> between different servers. Can I use it to access and edit directly >> the blob in that directory ? > > Don't know. Nope. The blob directory (even with regular ZODB) is a managed area like the data in your Data.fs. (You wouldn't go editing that data with your editor, would you?) Christian -- Christian Theune · c...@gocept.com gocept gmbh & co. kg · forsterstraße 29 · 06112 halle (saale) · germany http://gocept.com · tel +49 345 1229889 0 · fax +49 345 1229889 1 Zope and Plone consulting and development ___ For more information about ZODB, see the ZODB Wiki: http://www.zope.org/Wikis/ZODB/ ZODB-Dev mailing list - ZODB-Dev@zope.org https://mail.zope.org/mailman/listinfo/zodb-dev
Re: [ZODB-Dev] Status of gocept.zeoraid
On 20/10/2010 17:03, Sylvain Viollon wrote: >One of my customers would like to use gocept.zeoraid in production. >So him, and I have some questions: > >- Is it stable enough to be used in production ? No. >- Does it bring speed improvements over regular ZEO setup (I don't > think so) ? No. It is currently 5 times slower when tested with zodbshootout. >- Does it work with blobs ? I will have a blob directory shared > between different servers. Can I use it to access and edit directly > the blob in that directory ? Don't know. Chris ___ For more information about ZODB, see the ZODB Wiki: http://www.zope.org/Wikis/ZODB/ ZODB-Dev mailing list - ZODB-Dev@zope.org https://mail.zope.org/mailman/listinfo/zodb-dev
[ZODB-Dev] Status of gocept.zeoraid
Hello, One of my customers would like to use gocept.zeoraid in production. So him, and I have some questions: - Is it stable enough to be used in production ? - Does it bring speed improvements over regular ZEO setup (I don't think so) ? - Does it work with blobs ? I will have a blob directory shared between different servers. Can I use it to access and edit directly the blob in that directory ? Regards, Sylvain, -- Sylvain Viollon -- Infrae t +31 10 243 7051 -- http://infrae.com Hoevestraat 10 3033GC Rotterdam -- The Netherlands ___ For more information about ZODB, see the ZODB Wiki: http://www.zope.org/Wikis/ZODB/ ZODB-Dev mailing list - ZODB-Dev@zope.org https://mail.zope.org/mailman/listinfo/zodb-dev
Re: [ZODB-Dev] RelStorage and PostgreSQL's VACUUM
On Tue, Oct 19, 2010 at 1:05 AM, Noe Misael Nieto Arroyo wrote: > And if yes, What kind of VACUUM is good? FULL, CLUSTER? VACUUM FULL is almost never a good idea; autovac should be sufficient for most needs, and can be tweaked to meet particular performance issues. I have had very good results doing a CLUSTER after an initial zodbconvert run to significantly reduce the size of the database. I highly recommend doing CLUSTER after any large data loads. David Blewett ___ For more information about ZODB, see the ZODB Wiki: http://www.zope.org/Wikis/ZODB/ ZODB-Dev mailing list - ZODB-Dev@zope.org https://mail.zope.org/mailman/listinfo/zodb-dev