Oracle SGA like feature???

From: Keehan Mallon <keehan_mallon(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Oracle SGA like feature???
Date: 2002-10-02 17:38:11
Message-ID: 20021002173811.29822.qmail@web11208.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Thanks,

Keehan

__________________________________________________
Do you Yahoo!?
New DSL Internet Access from SBC & Yahoo!
http://sbc.yahoo.com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Diogo Biazus 2002-10-02 17:39:29 Question about Cursors
Previous Message David Link 2002-10-02 17:03:02 Trap Constraint Errors from perl DBI