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

 so, this command:


 {{{
 time ./raster2pgsql -t '256x256' ~/Downloads/HYP_LR/HYP_LR.tif unused >
 /dev/null
 Processing 1/1: /home/strk/Downloads/HYP_LR/HYP_LR.tif
 }}}

 Without the inlining of hex conversion:
 {{{
 real    0m8.120s
 user    0m7.012s
 sys     0m0.795s

 }}}

 With the inlining:
 {{{
 real    0m7.703s
 user    0m6.651s
 sys     0m0.868s
 }}}

 It's not such a big improvement.

 Excluding the hex conversion completely brings down the time to:
 {{{
 real    0m2.871s
 user    0m2.076s
 sys     0m0.642s
 }}}

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