[postgis-devel] [PostGIS] #1005: [raster] Problem with ST_SummaryStats(text, text) results

[PostGIS]

#1005: [raster] Problem with ST_SummaryStats(text, text) results
----------------------------+-----------------------------------------------
 Reporter:  pracine         |       Owner:  dustymugs    
     Type:  defect          |      Status:  assigned     
 Priority:  medium          |   Milestone:  PostGIS 2.0.0
Component:  postgis raster  |     Version:  trunk        
 Keywords:                  |  
----------------------------+-----------------------------------------------

Comment(by pracine):

 Interesting that:

 {{{
 SELECT (ss).*
 FROM (SELECT st_summarystats(rast) ss
       FROM srtm_22_03_tiled_100x100
       ) foo
 }}}

 takes 32 seconds on my machine and:

 {{{
 SELECT * FROM st_summarystats('srtm_22_03_tiled_100x100', 'rast');
 }}}

 takes only 6 seconds. How is this possible? We are counting the same
 number of pixels here.

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