[gdal-dev] postgis to esri shape slow

[Mario Jurcevic]

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.