[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 dustymugs):

 I think the source of the slowdown is the chunking of the source raster to
 256x256 tiles. For each tile, rt_raster_to_hexwkb is called.

 gdal_translate is faster because it isn't converting data to hex.
 Everything stays binary.

 Based upon that gprof, we'd have to see what we can do about improving hex
 conversion performance.

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/2798#comment:13>
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.