[prev in list] [next in list] [prev in thread] [next in thread] 

List:       zodb-dev
Subject:    [ZODB-Dev] Relstorage: postgres reports IDLE connection after first database write
From:       Jan-Wijbrand Kolman <janwijbrand () gmail ! com>
Date:       2013-09-05 11:02:06
Message-ID: l09ob6$v3d$1 () ger ! gmane ! org
[Download RAW message or body]

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 root. Storing an 
attribute on the app root, seems to not result in leaving an IDLEing 
connection.

Quick question: is this expected behaviour?

Kind regards, jw

ps. We suspected that his IDLEing connection keeps postgres from 
succefully running its auto vacuuming task, but we're actually not sure 
about that.

_______________________________________________
For more information about ZODB, see http://zodb.org/

ZODB-Dev mailing list  -  ZODB-Dev@zope.org
https://mail.zope.org/mailman/listinfo/zodb-dev
[prev in list] [next in list] [prev in thread] [next in thread]