[postgis-users] Raster ST_Union memory limit

[Bborie Park]

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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20140506/8ca35ab3/attachment.html>