[postgis-tickets] [PostGIS] #2798: raster2pgsql spins CPU on statement timeout

[PostGIS]

#2798: raster2pgsql spins CPU on statement timeout
---------------------+------------------------------------------------------
  Reporter:  strk    |       Owner:  dustymugs   
      Type:  defect  |      Status:  reopened    
  Priority:  medium  |   Milestone:  PostGIS GDAL
 Component:  raster  |     Version:  trunk       
Resolution:          |    Keywords:              
---------------------+------------------------------------------------------

Comment(by rouault):

 Sandro, there's no GDAL symbol in the above stacktrace. You should break
 several times to have a representative sample, and it is expected that
 sometimes it will show GDAL symbols. The performance might depend on if
 the original TIFF is tiled or not, and how raster2pgsql uses the GDAL API.
 But one hour is a lot.
 Did you just try "gdal_translate timeseq_change00_12.tif out.tif -co
 TILED=YES" ?

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/2798#comment:9>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.