Re: [ZODB-Dev] Problems packing Zope 2.9.8 storage

2009-09-18 Thread Shane Hathaway
Chris Withers wrote: > Shane Hathaway wrote: >> Look at this chart in particular, which suggests that RelStorage with >> PostgreSQL or MySQL is several times faster than ZEO for heavy read loads: > > Cool, now all I need is something like zeoraid for postgres (or, at a > push, mysql)... There a

Re: [ZODB-Dev] Problems packing Zope 2.9.8 storage

2009-09-18 Thread Chris Withers
Shane Hathaway wrote: > Look at this chart in particular, which suggests that RelStorage with > PostgreSQL or MySQL is several times faster than ZEO for heavy read loads: Cool, now all I need is something like zeoraid for postgres (or, at a push, mysql)... Chris -- Simplistix - Content Manage

Re: [ZODB-Dev] Problems packing Zope 2.9.8 storage

2009-09-14 Thread Benji York
On Mon, Sep 14, 2009 at 3:52 PM, Shane Hathaway wrote: > Benji York wrote: >> >> On Mon, Sep 14, 2009 at 2:44 PM, Shane Hathaway >> wrote: >>> >>> People have been looking at these performance charts for quite a while: >> >> Are the benchmarks publicly available?  I looked through the blog posts

Re: [ZODB-Dev] Problems packing Zope 2.9.8 storage

2009-09-14 Thread Shane Hathaway
Benji York wrote: > On Mon, Sep 14, 2009 at 2:44 PM, Shane Hathaway wrote: >> People have been looking at these performance charts for quite a while: > > Are the benchmarks publicly available? I looked through the blog posts > and svn.zope.org but couldn't find them. http://svn.zope.org/relstor

Re: [ZODB-Dev] Problems packing Zope 2.9.8 storage

2009-09-14 Thread Benji York
On Mon, Sep 14, 2009 at 2:44 PM, Shane Hathaway wrote: > People have been looking at these performance charts for quite a while: Are the benchmarks publicly available? I looked through the blog posts and svn.zope.org but couldn't find them. -- Benji York Senior Software Engineer Zope Corporatio

Re: [ZODB-Dev] Problems packing Zope 2.9.8 storage

2009-09-14 Thread Shane Hathaway
Chris Withers wrote: > Shane Hathaway wrote: >> Chris Withers wrote: >>> I thought RelStorage was slow at packing? >> Not anymore. I optimized packing last December/January and it has been >> plenty fast ever since, AFAIK. > > Interesting. Got any metrics on its speed compared to FileStorage, >

Re: [ZODB-Dev] Problems packing Zope 2.9.8 storage

2009-09-14 Thread Chris Withers
Shane Hathaway wrote: > Chris Withers wrote: >> I thought RelStorage was slow at packing? > > Not anymore. I optimized packing last December/January and it has been > plenty fast ever since, AFAIK. Interesting. Got any metrics on its speed compared to FileStorage, including packing? cheers,

Re: [ZODB-Dev] Problems packing Zope 2.9.8 storage

2009-09-14 Thread Shane Hathaway
Chris Withers wrote: > I thought RelStorage was slow at packing? Not anymore. I optimized packing last December/January and it has been plenty fast ever since, AFAIK. Shane ___ For more information about ZODB, see the ZODB Wiki: http://www.zope.org/W

Re: [ZODB-Dev] Problems packing Zope 2.9.8 storage

2009-09-14 Thread Chris Withers
Shane Hathaway wrote: >> There is a .old file there, but it was last modified over a week ago. > > The analysis phase of packing can take a long time. A week is too much, > though. :-) Yeah, this is off the back of an automated pack/backup/unpack/verify to keep two storages in sync on two data

Re: [ZODB-Dev] Problems packing Zope 2.9.8 storage

2009-09-14 Thread Shane Hathaway
Chris Withers wrote: > I've got a ZODB that's ballooned and I'm now having problems packing > with zeopack. > > I tried with zeopack, which appeared to just hang (still in top, but no > cpu usage for an hour or two), so I ctrl-c'ed it. > > Now when I try, I just get the text "Already packing" b