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
