> So, does anyone have any idea about the origin of this increase in
PostgreSQL activity and performance decrease?
Since pg_stat_activity is not showing anything, my typical troubleshooting
is this:
1. Have your app log the exact queries, along with the time it takes to
run. You can do this
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA256
Hi Julien,
The server is an SSD-based Hyper-V virtual machine running Debian GNU/Linux
with Python 3.9.2 and PostgreSQL 13.
We have 32 GB of RAM and only 4 are used so there is no swapping and there
is no I/O wait while looking at "top".
There is no
On Tue, Jun 06, 2023 at 09:17:18AM +0200, Thierry Florac wrote:
> Hi!
Hello,
> 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
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 metadat