Re: [ZODB-Dev] RelStorage 1.5.0b1 dry-run > two phase pack, better pack lock behaviour

2011-02-23 Thread Martijn Pieters
On Tue, Feb 22, 2011 at 22:51, Maurits van Rees wrote: > I wonder it it may help to set pack-gc to false during the first pack. > According to the docs this is faster, though it of course leaves more > unused objects behind.  Set pack-gc to the default true value for > subsequent packs.  Theoretic

Re: [ZODB-Dev] RelStorage 1.5.0b1 dry-run > two phase pack, better pack lock behaviour

2011-02-23 Thread Martijn Pieters
On Tue, Feb 22, 2011 at 21:41, Martijn Pieters wrote: > BTW, should I just commit the patch, or do you want to integrate it > yourself? Updated patch attached; added the options changes to component.xml and README.txt. -- Martijn Pieters twophasepack.patch Description: Binary data ___

[ZODB-Dev] RelStorage and MariaDB

2011-02-23 Thread Dinh Trung Viet
Hi all, Just wanted to let you know that I have successfully tested RelStorage with MariaDB (a community-developed branch of the MySQL database). The tests were performed on RelStorage 1.5b1, MariaDB 5.2 and Plone 4.0.2. All cases in mysql test were passed except replica (I haven't configure repl

Re: [ZODB-Dev] RelStorage and PostgreSQL's VACUUM

2011-02-23 Thread Maurits van Rees
Hi all, Reviving a thread from October 2010 about vacuuming in postgres. Op 20-10-10 17:35, David Blewett schreef: > On Tue, Oct 19, 2010 at 1:05 AM, Noe Misael Nieto Arroyo > wrote: >> And if yes, What kind of VACUUM is good? FULL, CLUSTER? > > VACUUM FULL is almost never a good idea; autovac

Re: [ZODB-Dev] RelStorage 1.5.0b1 dry-run > two phase pack, better pack lock behaviour

2011-02-23 Thread Martijn Pieters
On Wed, Feb 23, 2011 at 11:55, Martijn Pieters wrote: > Updated patch attached; added the options changes to component.xml and > README.txt. I've moved this patch to bitbucket at https://bitbucket.org/mjpieters/relstorage-mq/src/tip/twophasepack.patch and updated the README a little more to docum

Re: [ZODB-Dev] RelStorage 1.5.0b1 dry-run > two phase pack, better pack lock behaviour

2011-02-23 Thread Martijn Pieters
On Tue, Feb 22, 2011 at 21:41, Martijn Pieters wrote: > I'll look into working the locking idea into a patch too, > but I'll need help with supporting Postgres and MySQL as I don't know > their locking semantics. Both MySQL and Oracle support lock timeouts and already use a timeout for the commit