Opened 5 years ago

Last modified 11 months ago

#1583 new enhancement

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

Reported by: pracine Owned by: dustymugs
Priority: low Milestone: PostGIS 2.4.0
Component: raster Version: trunk
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 (12)

comment:1 Changed 5 years ago by 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...

comment:2 Changed 5 years ago by pracine

Milestone: PostGIS Raster 2.0.1PostGIS 2.0.1

comment:3 Changed 5 years ago by 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

comment:4 in reply to:  3 Changed 5 years ago by 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.

comment:5 Changed 5 years ago by dustymugs

Milestone: PostGIS 2.0.1PostGIS 2.0.2

comment:6 Changed 5 years ago by robe

Milestone: PostGIS 2.0.2PostGIS 2.0.3

comment:7 Changed 4 years ago by dustymugs

Milestone: PostGIS 2.0.3PostGIS 2.0.x

comment:8 Changed 4 years ago by 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.

comment:9 Changed 4 years ago by dustymugs

Milestone: PostGIS 2.0.4PostGIS 2.2.0
Owner: changed from pracine to dustymugs

comment:10 Changed 2 years ago by dustymugs

Priority: mediumlow

comment:11 Changed 21 months ago by robe

Milestone: PostGIS 2.2.0PostGIS 2.3.0

comment:12 Changed 11 months ago by robe

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