[gdal-dev] postgis to esri shape slow

[Jukka Rahkonen]

Mario Jurcevic <mario <at> geosar.ch> writes:

> 
> 
> On 04/30/2014 05:11 PM, Even Rouault wrote:
> > Not that much a big difference... Perhaps you should try to isolate
which layer
> > conversion if particuarly slower with ogr2ogr
> 
> I get big difference:
>   time ogr2ogr -sql 'select 
> "soft_gis_serial","Origine","Qualita","Genere",st_curvetoline("Geometria") 
> as Geometria from test_export."Copertura_del_suolo__SuperficieCS"'\
>  >  -f "ESRI Shapefile" out.shp PG:'host=localhost dbname=test_soft_gis 
> user=test_soft_gis password=passwd'
> Warning 6: Normalized/laundered field name: 'soft_gis_serial' to 
> 'soft_gis_s'
> 
> real	0m2.359s
> user	0m0.040s
> sys	0m0.004s
> 
> With debug on there there is many notice of ogr analyzing geom tables.
> Maybe that is, your dump miss has not the whole db.

Could you make one more test by creating a table that is already cleared
from curves inside PostGIS as 
create table curves_as_lines as
select [your sql];

This test should reveal if st_curvetoline is the bottleneck.

-Jukka Rahkonen-