[postgis-users] PostGIS Raster / Geom intersection perfromance.

[LewInMadrid]

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.