| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Ben Chobot <bench(at)silentmedia(dot)com> |
| Cc: | John R Pierce <pierce(at)hogranch(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Really out of memory? |
| Date: | 2009-06-02 20:45:57 |
| Message-ID: | 18576.1243975557@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Ben Chobot <bench(at)silentmedia(dot)com> writes:
> On Tue, 2 Jun 2009, Tom Lane wrote:
>> You don't have /proc/<pid>/limits ?
> Nope. I'd like to believe I would consider that "obviously relevant." :)
Next best thing I can think of is to stick "ulimit -a >/tmp/mylimits"
into the postgres initscript and restart.
If the initscript is starting postgres via "su -l", it might be better
to add the command in postgres' ~/.bashrc or some such place. You
have to consider the possibility that the su is changing the ulimit
environment.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Geoffrey | 2009-06-02 20:51:47 | Re: warm standby with WAL shipping |
| Previous Message | Geoffrey | 2009-06-02 20:41:51 | Re: warm standby with WAL shipping |