Opened 13 years ago

Last modified 7 years ago

#1583 new enhancement

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

Reported by: pracine Owned by: Bborie Park
Priority: low Milestone: PostGIS Fund Me
Component: raster Version: master
Keywords: Cc:

Description

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.

Change History (13)

comment:1 by pracine, 13 years ago

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...

comment:2 by pracine, 13 years ago

Milestone: PostGIS Raster 2.0.1PostGIS 2.0.1

comment:3 by pramsey, 13 years ago

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

in reply to:  3 comment:4 by pracine, 13 years ago

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.

comment:5 by Bborie Park, 12 years ago

Milestone: PostGIS 2.0.1PostGIS 2.0.2

comment:6 by robe, 12 years ago

Milestone: PostGIS 2.0.2PostGIS 2.0.3

comment:7 by Bborie Park, 12 years ago

Milestone: PostGIS 2.0.3PostGIS 2.0.x

comment:8 by robe, 11 years ago

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.

comment:9 by Bborie Park, 11 years ago

Milestone: PostGIS 2.0.4PostGIS 2.2.0
Owner: changed from pracine to Bborie Park

comment:10 by Bborie Park, 10 years ago

Priority: mediumlow

comment:11 by robe, 9 years ago

Milestone: PostGIS 2.2.0PostGIS 2.3.0

comment:12 by robe, 8 years ago

Milestone: PostGIS 2.3.0PostGIS 2.4.0

comment:13 by robe, 7 years ago

Milestone: PostGIS 2.4.0PostGIS Fund Me
Note: See TracTickets for help on using tickets.