Re: Oracle SGA like feature??? - Mailing list pgsql-general

From Jeff Davis
Subject Re: Oracle SGA like feature???
Date
Msg-id 200210021813.52382.list-pgsql-general@empires.org
Whole thread Raw
In response to Re: Oracle SGA like feature???  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: Oracle SGA like feature???  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-general
> 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




pgsql-general by date:

Previous
From: Mike Mascari
Date:
Subject: Re: database session variables
Next
From: Bruce Momjian
Date:
Subject: Re: Oracle SGA like feature???