That's great, thanks, and by adjusting the tile size the query is now down
to 0.7 seconds.
BTW. Your select had the alias "rast" missing.
SELECT (pvc).*
FROM (SELECT ST_ValueCount(rast,1,false) AS pvc
FROM (SELECT st_clip(rast, geom) *rast*
FROM temprast1000, nucleos
WHERE tag = '28079000101' AND ST_Intersects(rast, geom)
) foo2
) AS foo
ORDER BY (pvc).value;
--
View this message in context:
http://postgis.17.n6.nabble.com/PostGIS-Raster-Geom-intersection-perfromance-tp4748527p4863200.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
