Mauricio and list
On Thu, Mar 10, 2022, 05:21 Mauricio Vieira Cardoso Filho via Qgis-user <
qgis-user@lists.osgeo.org> wrote:
> 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
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: +556137995
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 yo
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 performan
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 Car
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 conn