Re: [gdal-dev] ogr2ogr Postgres upload performance

2022-05-27 Thread Even Rouault
Copy mode is not enabled by default for append, because of the potential risks of some columns being computed ones (among other thingsà, whereas when GDAL creates a table, it knows that such thing cannot happen. If you do basic use, you can definitely explicitly enable copy mode for append ope

Re: [gdal-dev] ogr2ogr Postgres upload performance

2022-05-27 Thread Alexandre Gacon
Hi Jukka, The problem is not related to a multi-table geopackage but to a set of geopackages with several tables in each : the first geopackage creates the tables so it can use the PG_USE_COPY but for the other files it has to go with the INSERT. Regards Alexandre Le ven. 27 mai 2022 à 15:12, Ra

Re: [gdal-dev] ogr2ogr Postgres upload performance

2022-05-27 Thread Rahkonen Jukka
Hi, If the problem is that PG_USE_COPY is applied only to the first layer of the multi-table GeoPackage then I would make a test by writing a separate ogr2ogr command for each layer. -Jukka Rahkonen- Lähettäjä: gdal-dev Puolesta Alexandre Gacon Lähetetty: maanantai 23. toukokuuta 2022 17.39 V