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

 Replying to [comment:8 robe]:
 > Pierre,
 >
 > Are you running on 8.4.  I think things might have changed in 9.0.
 check out my article - at the end see my compare between 8.4/9.0 -- but I
 never got a chance to further test to confirm.
 >
 > http://www.postgresonline.com/journal/archives/201-returns-table.html
 >

 Ok,

 {{{
 SELECT (ST_SummaryStats(rast)).* FROM srtm_22_03_tiled_100x100
 }}}

 still takes 32 seconds and strangely:

 {{{
 SELECT (st_summarystats('srtm_22_03_tiled_100x100', 'rast')).*
 }}}

 now takes also 32 seconds. So the fastest/shorter query is still

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

 That's on my old 8.4

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