[QGIS-Developer] Max connection PostgreSQL limit

Asim asimrp at lavabit.com
Fri Oct 7 14:20:33 PDT 2022


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 the workload is such that the connections idle with an in-progress 
transaction, the GUC idle_in_transaction_session_timeout may be helpful.

Asim




More information about the QGIS-Developer mailing list