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]> 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 > [image: cid:[email protected]] > > > _______________________________________________ > 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 -- Alessandro Pasotti w3: 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
