[postgis-users] ERROR: Out of memory

[Shane Spencer]

I think you don't have enough memory.  Atleast thats my first assumption :)

What kind of computer system is this running on? What are the hardware
specs? Do you have oodles of swap/paging memory available?  Do you
have enough disk space for Postgresql to create its own temporary
files?

Shane

On 10/8/07, Andreas Laggner <andreas.laggner at fal.de> wrote:
> Hi,
>
> i tried to perform the "union approach" from Kevin
> http://postgis.refractions.net/support/wiki/index.php?ExamplesOverlayTables
> the first query worked fine:
>  CREATE TABLE all_lines AS
>    SELECT St_ExteriorRing (the_geom) AS the_geom FROM ffhsinglerep
>    UNION ALL
>    SELECT St_ExteriorRing (the_geom) AS the_geom FROM spasinglerep;
>
> but in the second one i get an error:
> CREATE TABLE noded_lines AS
>    SELECT St_Union(the_geom) AS the_geom
>    FROM all_lines;
>
> ERROR: Out of memory
> SQL Status:53200
> Detail:Failed on request of size 20750552.
>
> If anybody knows what may be behind this error......i have no idea!
>
> Cheers      Andreas
>
>
> --
> Dipl. Geoökologe Andreas Laggner
> Institut für Ländliche Räume (LR)
> Bundesforschungsanstalt für Landwirtschaft (FAL)
>
> Institute of Rural Studies
> Federal Agricultural Research Centre (FAL)
>
> Bundesallee 50
> D-38116 Braunschweig
>
> Tel.: (+49) (0)531 596 5515
> Fax: (+49) (0)531 596 5599
> E-mail: andreas.laggner at fal.de
> Homepage: http://www.lr.fal.de/
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>