On 10/7/22 6:11 PM, Francisco Puga via QGIS-Developer wrote:
After a bit of research I think it is a database/networking issue. The
database is in a cloud provider and it seems that when the connection
has no activity for some time, it becomes unresponsive, but remains
idle in postgresql.
If
Thanks a lot Mathias,
It helps a lot. I didn't find anything weird about this, and it seems to
work correctly.
After a bit of research I think it is a database/networking issue. The
database is in a cloud provider and it seems that when the connection has
no activity for some time, it becomes unr
Hi Francisco,
QGIS does internally have connection pooling and uses up to 8 connections
per database.
It detects common database connections based on the URI, where there may be
different parameters used for layers even if they come from the same
database (e.g. SSL parameters, authentication, ...)
Hi,
I'm hitting the default (100) `max_connection` PostgreSQL limit with ~4
users using a QGIS project with ~25 layers/tables. I know that I can raise
the limit, but I'm trying to understand how QGIS handles database
connections.
I didn't find so much information about it:
1.
https://list