Hi! I'm working on a Pyramid application using ZODB and RelStorage to store Python objects into a PostgreSQL database. This application is a document management application using many file blobs which are stored on the filesystem (not in PostgreSQL), and a catalog is used to index documents metadatas. The application is running in an Apache process using mod_wsgi. My question is that we have another application which is used to transfer documents from another repository to this one; this application is only using one process and one thread to avoid ZODB conflicts on catalog updates; when the application is started, we handle approximately 120 transactions/minute and everything is OK but after 50 to 60 minutes, transactions rate is highly decreasing down to 30 tpm! While looking at server processes, it seems that most activity is related to PostgreSQL; I tried to disable autovacuum but it doesn't change anything! If I reload Apache service, the transaction rate is restarting at 120 tpm before decreasing after another hour of high activity... So, does anyone have any idea about the origin of this increase in PostgreSQL activity and performance decrease?
Best regards, Thierry -- https://www.ulthar.net -- http://pyams.readthedocs.io -- You received this message because you are subscribed to the Google Groups "pylons-discuss" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/pylons-discuss/CAPX_VWCNmjC6xvkRT8RnfHENEnP9KW2S3F5Eqc0BCt5M6y4ouA%40mail.gmail.com.
