[QGIS-Developer] Postgis loading using COPY instead of INSERTS?

[Matthias Kuhn]

On 6/10/17 8:55 PM, Régis Haubourg wrote:

>
>
> 2017-06-10 14:17 GMT+02:00 Matthias Kuhn <matthias at opengis.ch
> <mailto:matthias at opengis.ch>>:
>
>     > I'd estimate 90+% of the time we are bulk adding features we don't
>     > care about the updated feature ids, and it's only when adding small
>     > amounts of features that this updated id is used. Definitely for
>     > things like QgsVectorLayerExporter it's not required, so we'd
>     get the
>     > COPY speed boost used.
>     >
>     > Thoughts?
>
>
> Thanks for that! 
>  In edit mode, except for copy-paste , I don't really see where we
> could benefit from COPY instead of atomic INSERTS. What are the other
> use cases for batch insert deserving a COPY boost?
>
>
>     This would also help fixing https://issues.qgis.org/issues/16552
>     <https://issues.qgis.org/issues/16552>
>     Sounds like a good idea to me
>
>
> It seems fixed by Jurgen in fact :)
Views created with the DB manager work now, but the related issue
https://issues.qgis.org/issues/16083 still persists.


Something else to discuss is what will be sent along with the
`featureAdded(QgsFeatureId fid)` signal if the id is generated on the DB
but not propagated back to the client.

Matthias
>
> Régis 
>
>     Matthias
>     > Nyall
>     > _______________________________________________
>     > QGIS-Developer mailing list
>     > QGIS-Developer at lists.osgeo.or
>     <mailto:QGIS-Developer at lists.osgeo.org>
>
>  
>
>     g <mailto:QGIS-Developer at lists.osgeo.org>
>     > List info:
>     https://lists.osgeo.org/mailman/listinfo/qgis-developer
>     <https://lists.osgeo.org/mailman/listinfo/qgis-developer>
>     > Unsubscribe:
>     https://lists.osgeo.org/mailman/listinfo/qgis-developer
>     <https://lists.osgeo.org/mailman/listinfo/qgis-developer>
>     >
>
>     _______________________________________________
>     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
>     <https://lists.osgeo.org/mailman/listinfo/qgis-developer>
>     Unsubscribe:
>     https://lists.osgeo.org/mailman/listinfo/qgis-developer
>     <https://lists.osgeo.org/mailman/listinfo/qgis-developer>
>
>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-developer/attachments/20170610/bbc927ba/attachment.html>