From: | Jeff Davis <list-pgsql-general(at)empires(dot)org> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Oracle SGA like feature??? |
Date: | 2002-10-03 03:06:30 |
Message-ID: | 200210022006.30502.list-pgsql-general@empires.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
> >
> > 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.
Can postgres handle out-of-memory errors gracefully? I don't even know if it
would really make sense, but I suppose it could just give an error and
ROLLBACK the current transaction. If it had a minimal amount of memory (just
enough to perform basic tasks) to work with it seems that it could handle it
a little bit gracefully. Although this might be tough to do in a
cross-platform way.
Regards,
Jeff Davis
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2002-10-03 03:32:40 | Re: [HACKERS] Anyone want to assist with the translation of the |
Previous Message | Joe Conway | 2002-10-03 03:02:00 | Re: Oracle SGA like feature??? |