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@zope.org
http://mail.zope.org/mailman/listinfo/zodb-dev


_______________________________________________
For more information about ZODB, see the ZODB Wiki:
http://www.zope.org/Wikis/ZODB/

ZODB-Dev mailing list  -  ZODB-Dev@zope.org
http://mail.zope.org/mailman/listinfo/zodb-dev

Reply via email to