Re: Oracle SGA like feature???

Keehan Mallon wrote:
> At the company I work at we have undergone a fairly large consolidation
> plan.  Due to Oracle's new licensing schemes, we have opted for a model
> with many Oracle instances on shared hardware (IBM RS6000 AIX) where we
> pay a per CPU license.
>
> In this model, it sounds like we are allocating memory to each Oracle
> instance by setting the System Global Area (SGA) for each instance to a
> fixed value.  I'm no Oracle DBA, so I don't know all the details, but
> this essentially limits the amount of memory that each instance can
> consume.
>
> My question then is, does postgreSQL have any similar features that
> would allow hosting multiple instances running on the same hardware
> within fixed memory allocations???
>
> I am just curious if PostgreSQL may be able to replace some of our
> smaller Oracle instances in this environment with an eye to expansion
> to the larger instances in the future.

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.

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