Re: Oracle SGA like feature???

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

It might be a good idea to try to run all the databases under one postmaster,
since that way you can set the shared memory higher, and all the backends
would benefit.

Regards,
Jeff Davis