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

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 are

[ZODB-Dev] Problems packing Zope 2.9.8 storage

2009-09-14 Thread Chris Withers
Hi All, 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 back. There is a .old file

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 back.

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 database

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, Chris

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, including

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 sh...@hathawaymix.org 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

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 sh...@hathawaymix.org 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.

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 sh...@hathawaymix.org wrote: Benji York wrote: On Mon, Sep 14, 2009 at 2:44 PM, Shane Hathaway sh...@hathawaymix.org wrote: People have been looking at these performance charts for quite a while: Are the benchmarks publicly available?  I