Re: [ZODB-Dev] Optimizing RelStorage Packing for large DBs

2013-11-18 Thread Jan-Wijbrand Kolman
On 11/16/13 2:01 AM, Jens W. Klein wrote: Did I miss something? Any opinions much appreciated! Expect updates in this thread :) We did experience relstorage problems that we think could have been related to packing - we're not sure yet. So, I'm following this thread and your updates with

Re: [ZODB-Dev] Optimizing RelStorage Packing for large DBs

2013-11-18 Thread Jan-Wijbrand Kolman
On 11/18/13 12:19 PM, Jim Fulton wrote: On Fri, Nov 15, 2013 at 8:01 PM, Jens W. Klein j...@bluedynamics.com wrote: I started a new packing script for Relstorage (history free, postgresql). It is based on incoming reference counting. Did you look at zc.zodbdgc? I think it implements

[ZODB-Dev] Relstorage: postgres reports IDLE connection after first database write

2013-09-05 Thread Jan-Wijbrand Kolman
Hi, Recently we realized Relstorage seems to start and never close a database connection after the first write. This database connection is reported to IDLE in postgres. Note: this IDLEing connection is only started after adding an object to a container - in our testing a Zope application