| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Merlin Moncure <mmoncure(at)gmail(dot)com> |
| Cc: | Ioannis Anagnostopoulos <ioannis(at)anatec(dot)com>, pgsql-novice(at)postgresql(dot)org, ahodgson(at)simkin(dot)ca |
| Subject: | Re: Linux server connection process consumes all memory |
| Date: | 2011-12-06 17:10:46 |
| Message-ID: | 22700.1323191446@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
Merlin Moncure <mmoncure(at)gmail(dot)com> writes:
> *) You may want to consider changing your vm over commit settings
> and/or reducing swap in order to get your server to more aggressively
> return OOM to postgres memory allocation. The specific error returned
> to postgres for an OOM of course would be very helpful.
Yeah. I would try starting the postmaster under smaller ulimit settings
so that the kernel gives it ENOMEM before you start getting swapped.
When that happens, the backend will dump a memory map into the
postmaster log that would be very useful for seeing what is actually
happening here.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Didier Gasser-Morlay | 2011-12-07 07:20:09 | Re: How to add description for databases and tables? |
| Previous Message | Merlin Moncure | 2011-12-06 17:02:02 | Re: Linux server connection process consumes all memory |