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

Bborie Park dustymugs at gmail.com
Mon Mar 17 09:22:51 PDT 2014


We'll need a bit more info before any viable advice can be given. How big
is that polygon for the overlaps? Any error messages in the postgresql
logs? Is there just one date's scenes in the table or is it longitudinal?

-bborie
On Mar 17, 2014 9:16 AM, "Jackie" <justaniceguy.nguyen at gmail.com> wrote:

>  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
> database";
> Here's my query:
> SELECT ST_Union(rast, ARRAY[ROW(2,'LAST'),ROW(3,'LAST'),ROW(4,'LAST')]::
> unionarg[])
> FROM landsat8
> WHERE ST_Overlaps(polygon, rast_geom_4326)
>
>  I'm using PostGIS 2.1, my raster is retrieved from earthexplorer.usgs.gov
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20140317/0ff95b8d/attachment.html>


More information about the postgis-users mailing list