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 : [email protected];
skype: mauricio.cardoso1974
Em ter., 8 de mar. de 2022 às 23:36, Alexandre Neto
<[email protected]> 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
<[email protected]> 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 : [email protected];
skype: mauricio.cardoso1974
_______________________________________________
Qgis-user mailing list
[email protected]
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
_______________________________________________
Qgis-user mailing list
[email protected]
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
_______________________________________________
Qgis-user mailing list
[email protected]
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
