Hello,
The PG_USE_COPY parameter doesn't seem to work when appending several files
in the same table (replace the old data or something like that).
Postponing the creation of the spatial index does not seem to improve
things either.
I didn't try increasing the number of rows per transaction but
Hi,
Thank you for the input. I will give a try to different combination and
share my results.
Alexandre
Le lun. 23 mai 2022 à 19:43, Bo Victor Thomsen
a écrit :
> Hi Alexandre -
>
> I made a DOS script ages ago to try the different use cases. It's inserted
> as text below. It doesn't test ever
Hi Alexandre -
I made a DOS script ages ago to try the different use cases. It's
inserted as text below. It doesn't test every setup combination, only
the most pertinent.
The base gpkg layer is all the buildings i Denmark, ca. 5.8 million objects.
For my layer I had the following results:
1
I will try this way. To turn of SI creation : *SPATIAL_INDEX*=NONE
Le lun. 23 mai 2022 à 15:15, Jan Heckman a écrit :
> Perhaps the spatial index update (in de DB) slows the insertion.
> It might be more efficient to not create the SI in the first run,
> then insert more rows and create the SI a
Perhaps the spatial index update (in de DB) slows the insertion.
It might be more efficient to not create the SI in the first run,
then insert more rows and create the SI after all is done.
I don't know how to turn off SI creation in the command line.
On Mon, May 23, 2022 at 3:04 PM Alexandre Gaco
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
(
Javier hi,
Thank you very much for pointing to this.
After I updated to the newer GDAL git tag (at 22 may 2022) I’m now able to
compile it without problems with CMake.
The problem is solved.
Regards,
Kerim
>Понедельник, 23 мая 2022, 12:08 +03:00 от Javier Jimenez Shaw
>:
>
>Which version
Which version are you compiling? How are you compiling? (CMake?)
there was a fix in 3.5.0 recently related to that:
https://github.com/OSGeo/gdal/pull/5591
Cheers,
Javier
.___ ._ ..._ .. . ._. .___ .. __ . _. . __.. ... ._ .__
Entre dos pensamientos racionales
hay infinitos pensamientos irr