[postgis-users] Optimize query

[Nathaniel Clay]

Hi all,

I am having trouble geting the following query to run in a efficient manner:

Select ST_AsText(point) as point,ST_WorldToRasterCoordX(raster,point) as 
cx,ST_WorldToRasterCoordY(raster,point) as 
cy,ST_AsGDALRaster(raster,'GTiff') as image  from ( SELECT geom as 
point, ST_UNION(ST_CLIP(rast,ST_BUFFER(geom,10000))) as raster from 
wv_ned_utm83 , pointsouth where 
ST_INTERSECTS(rast,ST_Buffer(geom,10000)) and ST_VALUE(rast,geom) != 0 
GROUP BY geom limit 1 ) as foo"

Any suggestions or help would be greatly appreciated!!

Thanks,

Nathaniel Hunter Clay