[Qgis-user] QGIS slow performance with PostgreSQL/PostGIS

[Morten Storm]

I send the question below on Friday, but due to my email address not being updated, it apparently got rejected by the list. I have now updated my email address information and hope that this will be accepted:
----------------------------------------------
We experience slow performance in QGIS 3.xx (also tried with 3.20 with no noticable improvement). Data are stored in a PostgreSQL/PostGIS database and we have done enough testing that we do not believe that the database is the problem. And all tables are setup with spatial indexes and attribute indexes on fields used for filtering and visualization.

The slowness shows its ugly face when for instance the program freezes for a long time when performing even simple tasks, like e.g. saving the project or moving the map in the window.

The issue increases with the size of the project and we don't experience any noticable slowness in small to medium sized projects. The project I tested with most recently was about 4-5 MB when saved in QGIS 3 format (qgz) and about 40 MB when saved unzipped (qgs).

The project contains perhaps +/-100 vector layers from PostgreSQL/PostGIS data and a few online layers (basemap, etc.). Has anybody encountered anything similar and perhaps even found the reason and a solution? Or is anybody aware of some software that could help debug/analyze QGIS to find out what takes all that time?

As implied earlier we have tried and tested a lot including running QGIS on the same physical server as the database to eliminate network issues.


Kind regards,

Morten Storm
Chefkonsulent

[cid:image001.png at 01D795BA.F26E0070]<http://www.artogis.dk/>
[cid:image002.png at 01D795BA.F26E0070]
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20210823/8de394f8/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 4131 bytes
Desc: image001.png
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20210823/8de394f8/attachment-0002.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.png
Type: image/png
Size: 7727 bytes
Desc: image002.png
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20210823/8de394f8/attachment-0003.png>