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(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073