Re: [ZODB-Dev] Speedy RelStorage/PostgreSQL

2008-01-30 Thread Shane Hathaway
Flavio Coelho wrote: I think it would be a good idea to update the wiki with instructions of how to enable RelStorage for use with Standalone ZODB. I am particularly interested in doing it. I am anxious to benchmark it Well, let me think through what the wiki might say: 1. Download ZODB and

Re: [ZODB-Dev] Speedy RelStorage/PostgreSQL

2008-01-30 Thread Shane Hathaway
David Pratt wrote: Hi Shane. Congratulations. Can you advise of compatibility with ZODB 3.8. Many thanks. Yes, it's fully compatible now. A few tests didn't pass at first, but they only failed due to the lack of some stub methods. After I added those methods and created a patch that applies

Re: [ZODB-Dev] Speedy RelStorage/PostgreSQL

2008-01-30 Thread Shane Hathaway
Andreas Jung wrote: You're system is appearently very slow. Tested the same myself on an Opteron system (2.6 GHz) against a remote Postgres 8.1 DB...takes roughly 5-6 seconds and is basically as fast a FileStorage...great! Oops, you're right... I was running in a power saving mode. With the

Re: [ZODB-Dev] The write skew issue

2008-01-30 Thread Christian Theune
Hi, Dieter Maurer schrieb: Christian Theune wrote at 2008-1-29 16:32 +0100: ... When I looked up the definitions in Wikipedia about isolation and serializability again I didn't find any hint about the conditions how to decide which ordering is preferred. From Wikipedia ("http://en.wikipedi

Re: [ZODB-Dev] The write skew issue

2008-01-30 Thread Dieter Maurer
Christian Theune wrote at 2008-1-29 16:32 +0100: > ... >When I looked up the definitions in Wikipedia about isolation and >serializability again I didn't find any hint about the conditions how to >decide which ordering is preferred. >From Wikipedia ("http://en.wikipedia.org/wiki/Serializable_%28

Re: [ZODB-Dev] RelStorage now in Subversion

2008-01-30 Thread Jim Fulton
On Jan 27, 2008, at 3:11 AM, Shane Hathaway wrote: Thanks for this significant contribution! Andreas Jung wrote: Thanks a lot for the great work! One question: what is the ZODB patch actually doing? Is it for optimization purposes? Is it specfic to RelStorage or does it provide some gener

Re: [ZODB-Dev] Speedy RelStorage/PostgreSQL

2008-01-30 Thread David Pratt
Hi Shane. Congratulations. Can you advise of compatibility with ZODB 3.8. Many thanks. Regards, David Stephan Richter wrote: On Wednesday 30 January 2008, Shane Hathaway wrote: Kudos to the PostgreSQL team for building such a nice database. :-) I am saying this since at least 8 years now. :

Re: [ZODB-Dev] Speedy RelStorage/PostgreSQL

2008-01-30 Thread Stephan Richter
On Wednesday 30 January 2008, Shane Hathaway wrote: > Kudos to the PostgreSQL team for building such a nice database. :-) I am saying this since at least 8 years now. :-) But everyone went on the MySQL bandwagon. But the storage is great news! I will certainly keep this in mind for the current

Re: [ZODB-Dev] Speedy RelStorage/PostgreSQL

2008-01-30 Thread Flavio Coelho
Hi, great work! thanks! I think it would be a good idea to update the wiki with instructions of how to enable RelStorage for use with Standalone ZODB. I am particularly interested in doing it. I am anxious to benchmark it too especially the packing time On Jan 30, 2008 6:38 AM, Shane Hat

Re: [ZODB-Dev] Speedy RelStorage/PostgreSQL

2008-01-30 Thread Tarek Ziadé
On Jan 30, 2008 10:06 AM, Andreas Jung <[EMAIL PROTECTED]> wrote: > > > --On 30. Januar 2008 01:38:17 -0700 Shane Hathaway <[EMAIL PROTECTED]> > wrote: > > > Hi guys, > > > > I just committed some performance enhancements to RelStorage, then I > > performed two simple speed comparisons with FileSt

Re: [ZODB-Dev] Speedy RelStorage/PostgreSQL

2008-01-30 Thread Andreas Jung
--On 30. Januar 2008 01:38:17 -0700 Shane Hathaway <[EMAIL PROTECTED]> wrote: Hi guys, I just committed some performance enhancements to RelStorage, then I performed two simple speed comparisons with FileStorage using a stopwatch. I was surprised at the results. Test #2: I measured the

[ZODB-Dev] Speedy RelStorage/PostgreSQL

2008-01-30 Thread Shane Hathaway
Hi guys, I just committed some performance enhancements to RelStorage, then I performed two simple speed comparisons with FileStorage using a stopwatch. I was surprised at the results. Test #1: I measured the time to create a new database from scratch and start handling requests. I did thi