From: Gregory Stark <stark@enterprisedb.com>
To: Richard Yen <dba@richyen.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: postgres memory management issues?
Date: Fri, 07 Sep 2007 10:31:34 +0100
Message-ID: <874pi6zurt.fsf@oxford.xeocode.com> (raw)
In-Reply-To: <ADDEA1D0-FEEF-4FAD-950E-BC9E49439DF0@richyen.com>
References: <ADDEA1D0-FEEF-4FAD-950E-BC9E49439DF0@richyen.com>
"Richard Yen" <dba@richyen.com> writes:
> My understanding is that if any one postgres process's memory usage, plus the
> shared memory, exceeds the kernel limit of 4GB, then the kernel will kill the
> process off. Is this true? If so, would postgres have some prevention
> mechanism that would keep a particular process from getting too big? (Maybe
> I'm being too idealistic, or I just simply don't understand how postgres works
> under the hood)
I don't think you have an individual process going over 4G.
I think what you have is 600 processes which in aggregate are using more
memory than you have available. Do you really need 600 processes by the way?
You could try lowering work_mem but actually your value seems fairly
reasonable. Perhaps your kernel isn't actually able to use 16GB? What does cat
/proc/meminfo say? What does it say when this is happening?
You might also tweak /proc/sys/vm/overcommit_memory but I don't remember what
the values are, you can search to find them.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: stark@enterprisedb.com, dba@richyen.com
Subject: Re: postgres memory management issues?
In-Reply-To: <874pi6zurt.fsf@oxford.xeocode.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox