Hello, I am using ogr2ogr to upload data from several geopackages to a postgis database. Some tables contain thousands of rows (buildings for example).
The import of the first file is quite fast (tables are created for the first file so PG_USE_COPY is used) but the following file is much slower (using INSERT instead of COPY). How could I data insertion for the other files? Force PG_USE_COPY ? Increase the value of GT ? Postpone spatial index creation ? Should I concatenate all the geopackages first and then insert the data in Postgis? Thank you for your help -- Alexandre Gacon
_______________________________________________ gdal-dev mailing list [email protected] https://lists.osgeo.org/mailman/listinfo/gdal-dev
