[Qgis-user] QGIS - repeated connections

[Mauricio Vieira Cardoso Filho]

Hi Andreas,
Thanks for the info.
I did the configuration you suggested, but the QGis was very slow. I'll see
what I can configure inside PGBouncer to minimize this amount of
connections.
Thank you all for the support and guidance.

Best
Maurício Vieira Cardoso Filho
Gerente TI Infra
Tel: +556137995051
email : mcardoso at topocart.com.br;
skype: mauricio.cardoso1974


Em qua., 9 de mar. de 2022 às 09:17, Andreas Neumann <a.neumann at carto.net>
escreveu:

> 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/20220310/0f4dec0f/attachment.html>