Re: Oracle SGA like feature???

> >
> > Wouldn't it be pretty easy to run postgres through a process that has a
> > setrlimit on the memory? I assume that postgres handles memory errors
> > gracefully. I think the shared memory limit combined with setrlimit would
> > give him what he needs.
>
> Yes, you could do that.  Of course, a backend that exceeds it is going
> to die, but it seems that's what he wants.

Can postgres handle out-of-memory errors gracefully? I don't even know if it 
would really make sense, but I suppose it could just give an error and 
ROLLBACK the current transaction. If it had a minimal amount of memory (just 
enough to perform basic tasks) to work with it seems that it could handle it 
a little bit gracefully. Although this might be tough to do in a 
cross-platform way.

Regards,
	Jeff Davis