[postgis-users] Raster ST_Union memory limit

[Pierre Racine]

Thanks, 

The RAM limit is per row or per query? In other word, if a query produce fields smaller than my available RAM but the whole resulting table is bigger than my available RAM, are each resulting row flushed to the disk so that my whole query does not explode?

Pierre

> -----Original Message-----
> From: postgis-users-bounces at lists.osgeo.org [mailto:postgis-users-
> bounces at lists.osgeo.org] On Behalf Of Bborie Park
> Sent: Tuesday, May 06, 2014 9:52 AM
> To: PostGIS Users Discussion
> Subject: Re: [postgis-users] Raster ST_Union memory limit
> 
> RAM available.
> 
> -bborie
> 
> 
> On Tue, May 6, 2014 at 6:35 AM, Pierre Racine
> <Pierre.Racine at sbf.ulaval.ca> wrote:
> 
> 
> 	Hi,
> 
> 	What maximum size the result of a ST_Union(rast) can be if it is
> embedded in a ST_Tile() call?
> 
> 	SELECT ST_Tile(ST_Union(rast), 100, 100) rast FROM ...
> 
> 	The RAM available to PostgreSQL or the maximum size of a
> PostgreSQL field (1GB)?
> 
> 	Thanks,
> 
> 	Pierre
> 	_______________________________________________
> 	postgis-users mailing list
> 	postgis-users at lists.osgeo.org
> 	http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
> 
>