[ZODB-Dev] RelStorage, postgresql 9.2 and zc.async (plone.app.async)

[Simone Deponti]

On Fri, Mar 14, 2014 at 9:06 PM, Shane Hathaway <shane at hathawaymix.org> wrote:
>
>
> Are you using the "poll-interval" option? That option tells RelStorage to leave the transaction open. In practice, it's just wrong (although it doesn't corrupt any data.) I think we should remove that option.
>

No, I haven't set poll-interval explicitly in my configuration and
according to the doc this should be set to 0.

However, I failed to mention that I am not using any memcached (the
site is heavy on writes, and I thought it was not ideal).

Here is my config as extracted from zope.conf

<zodb_db main>
    # Main database
    cache-size 30000
    %import relstorage
    <relstorage>
        keep-history true
        blob-dir /mnt/cmsimages/production/raw
        replica-conf /srv/cms/production/var/replicas.conf
        pack-gc false
        <postgresql>
            dsn dbname='prod_zope' user='zope' port='5432'
        </postgresql>
    </relstorage>
    mount-point /
</zodb_db>

Also, this is used in a PostgreSQL HA (streaming replication) environment.


-- 
Simone Deponti
Project manager

>_
abstract.it - +39 06 92 94 69 38
...............................................................................
Registro Imprese di Napoli 788429 / Cap. Soc. 10.000 Euro I.V.
Avvertenze Legali - D. Lgs. 196/03 Tutela dei dati personali. Le informazioni
contenute in questo messaggio e in ogni eventuale allegato sono riservate e
ne è vietata ogni forma di diffusione. Se avete ricevuto questa comunicazione
per errore, Vi preghiamo di informare immediatamente il mittente del messaggio
e di eliminare l'e-mail.