Re: Why would this crash my server

Thanks again Tom - seems upgrading to 7.3 is the answer to most of my
probs - but I'm not sure if I want to open that can of worms - quick
clarification - do you think the problem occured at the moment of "fetch
into " or when it tried to return the results?

glenn


> Try 7.3 --- plpgsql functions don't support returning sets in
> earlier releases.  (You can't do it quite that way in 7.3,
> either; you need RETURN NEXT.  See the documentation.)
> 
> > --Heres the result, which comes after 5 min of hdd light thrashing,
> > capslock light doesn't respond and gui completely freezes.
> 
> On my machine, 7.2 fails with
>       ERROR:  Memory exhausted in AllocSetContextCreate(8192)
> after about 20 seconds.  There's no obvious loss of responsiveness of
> the rest of the machine meanwhile.  I suspect your machine is poorly
> configured --- better compare the max-memory-per-process kernel setting
> with the actual amount of physical RAM and swap space.  You've evidently
> got it set up in a way that allows a runaway process to drive it into
> swap hell.
> 
>                       regards, tom lane
> 


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to majordomo@xxxxxxxxxxxxxx)