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: [email protected] [mailto:postgis-users- > [email protected]] 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 > <[email protected]> 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: [email protected] [mailto:postgis- > users- > > [email protected]] 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 > > <[email protected]> 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 > > [email protected] > > http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users > > > > > > _______________________________________________ > postgis-users mailing list > [email protected] > http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users > > _______________________________________________ postgis-users mailing list [email protected] http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
