id,summary,reporter,owner,description,type,status,priority,milestone,component,version,resolution,keywords,cc
1659,[raster] ST_Union raster out of memory then kicks the bucket on windows 64bit,robe,pracine,"I ran this test on my mingw32 build (on PostgreSQL windows 32-bit on windows 7 64-bit) and my mingw64bit (on PostgreSQL windows 64-bit windows 2003).


{{{
SELECT ST_AsEWKT(ST_ConvexHull(ST_Union(rast1.rast, 1))) FROM (
		 	(SELECT ST_SetSRID(ST_SetValue(ST_AddBand(ST_MakeEmptyRaster( 100, 100, (i-1)*100, (i-1)*100, 0.0005, -0.0005, 0*i, 0*i), '16BSI'), i, (i+1),-6000),4326) As rast FROM generate_series(1,10) As i) ) As rast1 LIMIT 3;
}}}

On my postgsi 32 bit it gives error

{{{
NOTICE:  Neither raster provided has a NODATA value for the specified band indices.  NODATA value set to minimum possible for 16BSI
CONTEXT:  PL/pgSQL function ""_st_mapalgebra4unionstate"" line 13 at RETURN
SQL function ""_st_mapalgebra4unionstate"" statement 1
ERROR:  out of memory
DETAIL:  Failed on request of size 373628520.
CONTEXT:  PL/pgSQL function ""_st_mapalgebra4unionstate"" line 13 at RETURN
SQL function ""_st_mapalgebra4unionstate"" statement 1

********** Error **********

ERROR: out of memory
SQL state: 53200
Detail: Failed on request of size 373628520.
Context: PL/pgSQL function ""_st_mapalgebra4unionstate"" line 13 at RETURN
SQL function ""_st_mapalgebra4unionstate"" statement 1

}}}

on the 64-bit build it gives


{{{
NOTICE:  Neither raster provided has a NODATA value for the specified band indices.  NODATA value set to minimum possible for 16BSI
CONTEXT:  PL/pgSQL function ""_st_mapalgebra4unionstate"" line 13 at RETURN
SQL function ""_st_mapalgebra4unionstate"" statement 1
********** Error **********
}}}

Then just kills the service.",defect,closed,medium,PostGIS 2.1.0,raster,trunk,fixed,"mingw windows 64bit, 32bit",