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

 gdal_translate seems to be lighter on the CPU:
 {{{
   PID USER      PR  NI  VIRT  RES  SHR S  %CPU %MEM    TIME+  COMMAND
   770 strk      20   0  207m  63m 1004 D  41.8  1.6   1:44.72
 gdal_translate
 }}}

 Also, it took 6m15s to complete the conversion to TIF:
 {{{
 [strk at cdb:~/Downloads/change] time gdal_translate timeseq_change00_12.tif
 out.tif -co TILED=YES
 Input file size is 172000, 68000
 0...10...20...30...40...50...60...70...80...90...100 - done.

 real    6m15.583s
 user    0m48.100s
 sys     1m17.855s
 }}}

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