[postgis-users] Raster ST_Union memory limit

[Pierre Racine]

I tend to think the opposite since I already produced 30 GB tables on a machine with 8 GB of RAM..... I guess once finished, every row is flushed to the disk and its RAM share freed. 

> -----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 10:03 AM
> To: PostGIS Users Discussion
> Subject: Re: [postgis-users] Raster ST_Union memory limit
> 
> I think your query will explode...
> 
> 
> On Tue, May 6, 2014 at 7:01 AM, Pierre Racine
> <Pierre.Racine at sbf.ulaval.ca> wrote:
> 
> 
> 	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
> 	>
> 	>
> 
> 	_______________________________________________
> 	postgis-users mailing list
> 	postgis-users at lists.osgeo.org
> 	http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
> 
>