Skip site navigation (1) Skip section navigation (2)

Re: Linux server connection process consumes all memory

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 (view raw or flat)
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

In response to

Responses

pgsql-novice by date

Next:From: Didier Gasser-MorlayDate: 2011-12-07 07:20:09
Subject: Re: How to add description for databases and tables?
Previous:From: Merlin MoncureDate: 2011-12-06 17:02:02
Subject: Re: Linux server connection process consumes all memory

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group