[postgis-users] ST_Union() about 1179 raster-tiles cause ProgreSQL crashes

Jackie justaniceguy.nguyen at gmail.com
Mon Mar 17 09:15:57 PDT 2014

Hi PostGIS users,
I have a PostGIS database, which stores raster from Landsat 8. Each 
scene was divided with tile-size 500x500. Then each row in database will 
keep 1 tile with 11 bands (except band No. 8).
I'm trying to ST_Union() about 1179 raster-tiles with 3 bands (2,3,4) 
and pgAdminIII shows a window said "Connection lost - Try to reconnect 
Here's my query:
SELECT ST_Union(rast, 
FROM landsat8
WHERE ST_Overlaps(polygon, rast_geom_4326)

I'm using PostGIS 2.1, my raster is retrieved from 
earthexplorer.usgs.gov <http://earthexplorer.usgs.gov/>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20140317/5eec901a/attachment.html>

More information about the postgis-users mailing list