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

[PostGIS]

#2822: Slow _add_raster_constraint_extent
--------------------+-------------------------------------------------------
 Reporter:  strk    |       Owner:  dustymugs
     Type:  defect  |      Status:  new      
 Priority:  medium  |   Milestone:           
Component:  raster  |     Version:  2.1.x    
 Keywords:          |  
--------------------+-------------------------------------------------------

Comment(by dustymugs):

 There are two parts to that constraint. The
 envelope(collect(envelope(rast))) creates the reference for the
 constraint. When the constraint is applied to the column, the column needs
 to be checked against the constraint. The check is
 coveredby(envelope(rast), geom). I suppose that coveredby is slowing
 things down. Could just be envelope(rast) && geom.

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