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
