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

[Jackie]

Ngày 2014-03-17 11:22 PM, Bborie Park vie^'t:
>
> 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
>
> _______________________________________________ postgis-users mailing 
> list postgis-users at lists.osgeo.org 
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users 
Hi bborie,
PostgreSQL crashed before showing any message. It run for about 
600,000,000 ms then popup a window say "connection is lost".
My raster's date is in range 15/04/2013 - 20/02/2014. By the way, I 
don't know how to query 1 date's scenes or 16-days scenes (The Landsat 8 
satellite images the entire Earth every 16 days).
Here's my polygon:
ST_GeomFromText('POLYGON((105.78873 21.38659, 106.49185 21.38659, 
105.78873 20.71758, 106.49185 20.71758, 105.78873 21.38659))', 4326)
Thank you!
-Jackie.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20140318/028c2538/attachment.html>