(re-adding list)
Le 14/03/2024 à 18:58, Robin Wilson a écrit :
Hi Even,
Perfect - adding —config PG_USE_COPY YES solved it. I’ll write a blog
post about this that hopefully will be found by someone with the same
issue in future.
You may also suggest documentation enhancement to
https://gdal.org/drivers/vector/pg.html . There's the convenient "Edit
on GitHub" button at the top right
For context, is there a particular reason why this is only enabled by
default when you’re creating a new table?
Yes, this is related to unique identifiers. At table creation, one can
make the reasonable expectation that no other process will concurrently
update the table since it didn't exist before. When updating/appending,
that hypothesis is less likely, hence it is safer to fallback to the
slower INSERT mode. I presume in the Azure context that you have a
client->server->client round-trip at each feature insertion.
For what it’s worth, I was running this on GDAL 3.8.3 - I checked it
was recent, but forgot to include it in my first email.
Thanks,
Robin
--
http://www.spatialys.com
My software is free, but my time generally not.
_______________________________________________
gdal-dev mailing list
gdal-dev@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/gdal-dev
