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

[Alessandro Pasotti]

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> 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:image001.png at 01D34C22.F8A861A0]
>
>
> _______________________________________________
> QGIS-Developer mailing list
> 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-developer/attachments/20200124/cbfcab73/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image003.jpg
Type: image/jpeg
Size: 4649 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/qgis-developer/attachments/20200124/cbfcab73/attachment-0001.jpg>