[postgis-users] ERROR: Out of memory

[Andreas Laggner]

Moin Moin,

thanks for your tipps. I solved this problem yesterday evening by giving 
the postgresql installation on the server more buffer memory.

cheers      Andreas


Shane Spencer schrieb:
> 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
>>
>>     
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>   


-- 
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/