[postgis-users] Memory exhausted in AllocSetAlloc(32)

[Paul Ramsey]

Have you watched it in top? Does the postgres backend in fact grow to a 
size similar to your memory footprint? Always good to check the obvious 
answers first... :)

Düster Horst wrote:
> I try to manipulate a table with 140000 records with
>  
> delete from table  where archive=1;
>  
>  
> The server breaks with ERROR: Memory exhausted in AllocSetAlloc(32). 
>  
> System tru64 5.1
>  
> with the following system limits:
> putime         unlimited
> filesize        unlimited
> datasize        1048576 kbytes
> stacksize       8192 kbytes
> coredumpsize    unlimited
> memoryuse       503016 kbytes
> descriptors     4096 files
> addressspace    4194304 kbytes
>  
> Any hints??
>  
> Horst
> 
> ----------------------------------------------------------------------- 
> Mit freundlichen Grüssen 
> 
> Dr. Horst Düster 
> Leiter 
> Abteilung SO!GIS Koordination
> Rötihof 
> 4500 Solothurn 
> 
> Tel.: 032 627 25 32 
> Fax: 032 627 22 14
> 
> horst.duester at bd.so.ch <mailto:horst.duester at bd.so.ch>  
>  <http://www.sogis.so.ch/> www.sogis.so.ch
> 
> 
>  
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users


-- 
       __
      /
      | Paul Ramsey
      | Refractions Research
      | Email: pramsey at refractions.net
      | Phone: (250) 885-0632
      \_