Changes between Initial Version and Version 1 of Ticket #4463


Ignore:
Timestamp:
Jul 26, 2019, 4:20:26 PM (6 months ago)
Author:
robe
Comment:

Legend:

Unmodified
Added
Removed
Modified
  • Ticket #4463 – Description

    initial v1  
    2929
    3030
    31 --this doesn't use an index on PostgreSQL 12 (though it has option of a centroid functional index and a raster ST_ConvexHull(rast) index
     31--this doesn't use an index on PostgreSQL 12 (though it has option of a centroid functional index and a raster ST_ConvexHull(rast) index 
    3232-- TODO: test on 11, we suspect it will be able to use the indexes
    3333
     
    4040}}}
    4141
    42 The issue as RhodiumToad explained on IRC is the ST_Intersects(raster,geometry), geometry,raster  is still relying on _ST_Intersects which doesn't use the fancy function costing so is suffering from the high costs we've put in place.
     42The issue as RhodiumToad explained on IRC http://irclogs.geoapt.com/postgis/%23postgis.2019-07-26.log is the ST_Intersects(raster,geometry), geometry,raster  is still relying on _ST_Intersects which doesn't use the fancy function costing so is suffering from the high costs we've put in place.
    4343
    4444