[raster] Optimize ST_Intersection(raster, geometry) with ST_Clip()

[pracine]

Now that we can ST_Clip() a raster we can optimize the vector space ST_Intersection(raster, geometry) so that it vectorize only the required extent (the intersection of the geometry extent and the raster extent) instead of all the tile.

[pracine]

There should be a threshold were it is worth doing so, like when the intersecting extent is XX% smaller than the raster extent. Some test needed…

[pramsey]

Note that patch releases should not be changing functionality. There seem to be a number of raster enhancement tickets on the 2.0.1 milestone, which should properly be 2.1.x

[pracine]

Replying to pramsey:

Note that patch releases should not be changing functionality. There seem to be a number of raster enhancement tickets on the 2.0.1 milestone, which should properly be 2.1.x

Not this one since the change is inside ST_Intersection and totally transparent to the user.

[robe]

Is this issue still valid in 2.1 and 2.2. If it is I would suggest just pushing it and not bothering making changes to 2.0. The api has changed enough between 2.0 and 2.1 to make supporting performance enhancements in 2.0 annoying.