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 , 13 years ago
comment:2 by , 13 years ago
Milestone: | PostGIS Raster 2.0.1 → PostGIS 2.0.1 |
---|
follow-up: 4 comment:3 by , 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
comment:4 by , 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 , 12 years ago
Milestone: | PostGIS 2.0.1 → PostGIS 2.0.2 |
---|
comment:6 by , 12 years ago
Milestone: | PostGIS 2.0.2 → PostGIS 2.0.3 |
---|
comment:7 by , 12 years ago
Milestone: | PostGIS 2.0.3 → PostGIS 2.0.x |
---|
comment:8 by , 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 , 11 years ago
Milestone: | PostGIS 2.0.4 → PostGIS 2.2.0 |
---|---|
Owner: | changed from | to
comment:10 by , 10 years ago
Priority: | medium → low |
---|
comment:11 by , 9 years ago
Milestone: | PostGIS 2.2.0 → PostGIS 2.3.0 |
---|
comment:12 by , 8 years ago
Milestone: | PostGIS 2.3.0 → PostGIS 2.4.0 |
---|
comment:13 by , 7 years ago
Milestone: | PostGIS 2.4.0 → PostGIS Fund Me |
---|
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...