On 04/28/2014 08:02 PM, Even Rouault wrote:
Le lundi 28 avril 2014 16:47:49, Mario Jurcevic a écrit :
Hi,
I try to export postgis tables ( 200 ) to shape; It seems ogr2ogr is
much more slow than "pgsql2shp" from postgis.
ogr2ogr: about 15 minutes
pgsql2shp: about 2 minutes
Any known reason for that?
Interesting. I don't have a particular reason coming to mind. Which GDAL,
PostGIS and PostgreSQL versions do you use ?
Well, one idea I could have is if some of your tables have polygons or
multipolygons with a lot of inner rings/holes. The shapefile exporter might be
slow on this. If you've indeed that situation, perhaps you could exclude them
from the timing to compare if that makes a difference
Could you share a dump of the tables (possibly a shorter extract that would
still exhibit the issue) so that it can be analyzed ?
Even
Postgresql 9.1.3
Postgis 2.0.4
gdal 1.9.2
Tables have MULTIPOLYGONS and MULTILINESTRING.
The export is done from Java by invoking for each table the ogr2ogr
command. Same for "pgsqltoshape".
_______________________________________________
gdal-dev mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/gdal-dev
