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 : mcard...@topocart.com.br; skype: mauricio.cardoso1974 Em qua., 9 de mar. de 2022 às 09:17, Andreas Neumann <a.neum...@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 : mcard...@topocart.com.br; > skype: mauricio.cardoso1974 > > Em ter., 8 de mar. de 2022 às 23:36, Alexandre Neto <senhor.n...@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@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 : mcard...@topocart.com.br; > skype: mauricio.cardoso1974 > _______________________________________________ > Qgis-user mailing list > Qgis-user@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@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@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user