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
regards, tom lane
In response to
pgsql-novice by date
|Next:||From: Didier Gasser-Morlay||Date: 2011-12-07 07:20:09|
|Subject: Re: How to add description for databases and tables?|
|Previous:||From: Merlin Moncure||Date: 2011-12-06 17:02:02|
|Subject: Re: Linux server connection process consumes all memory|