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:[email protected]] De : Alessandro Pasotti [mailto:[email protected]] Envoyé : vendredi 24 janvier 2020 10:40 À : VOLPES-EXT, Jacky <[email protected]> Cc : [email protected] 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 <[email protected]<mailto:[email protected]>> 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:[email protected]] _______________________________________________ QGIS-Developer mailing list [email protected]<mailto:[email protected]> 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>
_______________________________________________ QGIS-Developer mailing list [email protected] List info: https://lists.osgeo.org/mailman/listinfo/qgis-developer Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-developer
