Re: Oracle SGA like feature???

Jeff Davis wrote:
> > We do allow limitation on how mush _shared_ memory an instanace can
> > have, but each session allocates its own memory independently as a Unix
> > process.  We do support multiple databases and, in 7.3beta, schemas.
>
> 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.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073