[postgis-tickets] [PostGIS] #2822: Slow _add_raster_constraint_extent

[PostGIS]

#2822: Slow _add_raster_constraint_extent
---------------------+------------------------------------------------------
  Reporter:  strk    |       Owner:  dustymugs    
      Type:  defect  |      Status:  closed       
  Priority:  medium  |   Milestone:  PostGIS 2.2.0
 Component:  raster  |     Version:  trunk        
Resolution:  fixed   |    Keywords:  history      
---------------------+------------------------------------------------------

Comment(by strk):

 Quick test on a table with 19208 rows with 256x256 tiles brings down the
 _add_raster_constraint_extent time from ~23 seconds to ~15 seconds.
 select st_envelope(rast) takes ~7.5 seconds, so the math is one go to
 compute max extent and another go to check the constraint, which makes
 indeed those ~15 seconds.

 Now I wonder if st_envelope could be made faster (does it detoast a single
 slice of the toast already?)

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