| From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
|---|---|
| To: | Jeff Davis <list-pgsql-general(at)empires(dot)org> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Oracle SGA like feature??? |
| Date: | 2002-10-03 02:31:47 |
| Message-ID: | 200210030231.g932Vln23230@candle.pha.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Jeff Davis wrote:
> > 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.
Yes, you could do that. Of course, a backend that exceeds it is going
to die, but it seems that's what he wants.
--
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joe Conway | 2002-10-03 03:02:00 | Re: Oracle SGA like feature??? |
| Previous Message | Bruce Momjian | 2002-10-03 02:29:13 | Re: Advice: Where could I be of help? |