[ZODB-Dev] Re: PGStorage

Laurence Rowe l at lrowe.co.uk
Wed Jan 23 11:30:25 EST 2008


PGStorage does require packing currently, but it would be fairly trivial 
to change it to only store single revisions. Postgres would still ensure 
mvcc. Then you just need to make sure postgres auto-vacuum daemon is 
running.

Laurence

David Pratt wrote:
> Yes, Shane had done some benchmarking about a year or so ago. PGStorage 
> was actually faster with small writes but slower for larger ones. As far 
> as packing, as a zodb implementation, packing is still required to 
> reduce the size of data in Postgres. BTW Stephan, where is Lovely using 
> it - a site example? I had read some time ago that they were exploring 
> it but not that it was being used.
> 
> Regards,
> David
> 
> Stephan Richter 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.
>>
>> Regards,
>> Stephan
> _______________________________________________
> For more information about ZODB, see the ZODB Wiki:
> http://www.zope.org/Wikis/ZODB/
> 
> ZODB-Dev mailing list  -  ZODB-Dev at zope.org
> http://mail.zope.org/mailman/listinfo/zodb-dev
> 



More information about the ZODB-Dev mailing list