[ZODB-Dev] PGStorage

[Andreas Jung]

--On 23. Januar 2008 18:17:18 +0100 Andreas Jung <lists at zopyx.com> wrote:

>
>
> --On 22. Januar 2008 21:17:45 -0500 Stephan Richter
> <srichter at cosmos.phy.tufts.edu> wrote:
>
>> On Tuesday 22 January 2008, Dieter Maurer wrote:
>>> "OracleStorage" was abandoned because it was almost an order
>>> or magnitude slower than "FileStorage".
>>
>> Actually, Lovely Systems uses PGStorage because it is faster for them.
>>
>
> It would be interesting where PGS is faster than filestorage. Ok, I just
> tried made a simple benchmark for testing write performance. I created a
> Plone site and then created a copy using copy/paste within the ZMI.
> (AMD Dualcore 2.6 GHz, Postgres 7.4.7 running on dedicated DB server):
>
> Copy&Paste using Filestorage: 3-4 seconds
> Copy&Paste using PGStorage: 30-40 seconds
>

Alan asked me to so some further testing. I wrote a small script
creating 100 Documents within one transaction (both in CMF and Plone)
and I calculated the transaction time (not included the overhead
for creating the instances)...the numbers are pretty much the self-speaking:

                   CMF                Plone
PGStorage        10-12 secs           15-18 secs
Filestorage      0.3-0.4 secs         0.4-0.6 secs

Andreas
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 186 bytes
Desc: not available
Url : http://mail.zope.org/pipermail/zodb-dev/attachments/20080124/2c50ef39/attachment.bin