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

[Régis Haubourg]

2017-06-10 14:17 GMT+02:00 Matthias Kuhn <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
> Sounds like a good idea to me
>
>
It seems fixed by Jurgen in fact :)

Régis

> Matthias
> > Nyall
> > _______________________________________________
> > QGIS-Developer mailing list
> > QGIS-Developer at lists.osgeo.or <QGIS-Developer at lists.osgeo.org>
>


> g <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
> >
>
> _______________________________________________
> 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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-developer/attachments/20170610/6ff4c23a/attachment.html>