[Qgis-user] QGIS - repeated connections

[Andreas Neumann]

Hi,

Yes, you can limit the nr of CPU cores that render in QGIS - and this 
will limit the PG connections.

Menu "Settings" --> "Options" --> "Rendering".

If you disable the checkbox "Render layers in parallel using many CPU 
cores", this will force QGIS to go single threaded for drawing - or you 
can use the setting to the right of it and set it to use max 2 CPU 
cores, which will restrict it to two connectsions max.

The much better solution, however, would be to use a connection pool 
solution (like pgBouncer). Then the idle connections will be temporarily 
disconnected from the PG server. See the pgBouncer documentation.

Greetings,

Andreas

On 2022-03-09 12:23, Mauricio Vieira Cardoso Filho via Qgis-user wrote:

> Hi Alexandre,
> Thanks for the answer. Is there any way to prevent this from happening? 
> - I ask because I have many users who connect to the postgres database 
> through QGIS and for each user connection, it is generating five 
> connection sessions in the database. And that has killed Postgres's 
> performance. Is there a way to prevent QGIS from generating this amount 
> of connections?
> 
> Best Regards
> 
> Maurício Vieira Cardoso Filho
> Gerente TI Infra
> Tel: +556137995051
> email : mcardoso at topocart.com.br;
> skype: mauricio.cardoso1974
> 
> Em ter., 8 de mar. de 2022 às 23:36, Alexandre Neto 
> <senhor.neto at gmail.com> escreveu:
> Hello Mauricio,
> 
> That is "normal". Several different components of QGIS can establish 
> different and independent connections to PostgreSQL. For example, the 
> browser panel can create a connection, the database manager another, 
> and so on.
> 
> Alexandre Neto
> 
> A terça, 8/03/2022, 20:14, Mauricio Vieira Cardoso Filho via Qgis-user 
> <qgis-user at lists.osgeo.org> escreveu:
> I use QGIS 3.16 and I'm having an operation that I believe to be 
> abnormal. I use QGIS connected to a postgres database. My problem is 
> that QGIS is creating five simultaneous connections for each database 
> user. (For example, when opening qgis and connecting to the bank, on my 
> server I have five connections created with my username). Does anyone 
> have any idea what could be happening?
> 
> Best
> 
> Maurício Vieira Cardoso Filho
> Gerente TI Infra
> Tel: +556137995051
> email : mcardoso at topocart.com.br;
> skype: mauricio.cardoso1974 
> _______________________________________________
> Qgis-user mailing list
> Qgis-user at lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

_______________________________________________
Qgis-user mailing list
Qgis-user at lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20220309/7fc465dd/attachment.html>