[QGIS-Developer] Estimate metadata when loading a vector layer

[VOLPES-EXT, Jacky]

Hi,

After searching into QGIS source code again, I found the option to set a project “trusted”, which bypasses the checks about the extent and other metadata on postgresql.
It’s exactly what I need!

Have a good week,
BR

Jacky Volpes
Développeur QGIS
HR-Team pour la Société du Canal de Provence
Direction des Systèmes d’Information

Tél. 04 42 66 70 34
Le Tholonet - CS 70064 - 13182 Aix-en-Provence CEDEX 5
[cid:image001.png at 01D34C22.F8A861A0]

De : Alessandro Pasotti [mailto:apasotti at gmail.com]
Envoyé : vendredi 24 janvier 2020 10:40
À : VOLPES-EXT, Jacky <Jacky.VOLPES-EXT at canal-de-provence.com>
Cc : qgis-developer at lists.osgeo.org
Objet : Re: [QGIS-Developer] Estimate metadata when loading a vector layer


Please file an issue attaching a test project and a DB dump (with a couple of records to test with, no need for a big dump).

On Fri, Jan 24, 2020 at 10:37 AM VOLPES-EXT, Jacky <Jacky.VOLPES-EXT at canal-de-provence.com<mailto:Jacky.VOLPES-EXT at canal-de-provence.com>> wrote:
Hi,

After many hours searching the web, I didn’t find any solution, so I come to the dev community.

I have an issue when loading a big layer with PostGIS :


-          On QGIS 2.14 it was very fast (~100 ms) using the flag “useEstimatedMetadata” set to True

-          On QGIS 3.4 it is very slow (~1min) using the flag “checkPrimaryKeyUnicity” set to False

o   st_extent(geom) is run to load the layer and takes about 1 min (I wish st_estimated_extent was used)

Any idea please ?
Thanks a lot,

BR

Jacky Volpes
Développeur QGIS
HR-Team pour la Société du Canal de Provence
Direction des Systèmes d’Information

Tél. 04 42 66 70 34
Le Tholonet - CS 70064 - 13182 Aix-en-Provence CEDEX 5
[cid:image001.png at 01D34C22.F8A861A0]

_______________________________________________
QGIS-Developer mailing list
QGIS-Developer at lists.osgeo.org<mailto:QGIS-Developer at lists.osgeo.org>
List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer


--
Alessandro Pasotti
w3:   www.itopen.it<http://www.itopen.it>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-developer/attachments/20200127/cd85e177/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.jpg
Type: image/jpeg
Size: 4649 bytes
Desc: image001.jpg
URL: <http://lists.osgeo.org/pipermail/qgis-developer/attachments/20200127/cd85e177/attachment-0002.jpg>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.jpg
Type: image/jpeg
Size: 4649 bytes
Desc: image002.jpg
URL: <http://lists.osgeo.org/pipermail/qgis-developer/attachments/20200127/cd85e177/attachment-0003.jpg>