When I try the same command with a tiled raster the indexes don't seem to be
used.
If I specify the tile directly with rid=3, the query takes about 2 second.
If not, it takes around 30seconds.
SELECT (pvc).* FROM (SELECT ST_ValueCount(rast,1,false) AS pvc
FROM ( SELECT st_clip(rast,
(SELECT geom FROM nucleos WHERE tag =
'28079000101')) rast
FROM temprast where rid=3) foo2
) AS foo ORDER BY (pvc).value;
What can I do to make it use the raster index?
--
View this message in context:
http://postgis.17.n6.nabble.com/PostGIS-Raster-Geom-intersection-perfromance-tp4748527p4862412.html
Sent from the PostGIS - User mailing list archive at Nabble.com.
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
