From: Michael Stone <mstone+postgres@mathom.us>
To: pgsql-performance@postgresql.org
Subject: Re: postgres memory management issues?
Date: Fri, 07 Sep 2007 06:11:21 -0400
Message-ID: <20070907101120.GF1795@mathom.us> (raw)
In-Reply-To: <ADDEA1D0-FEEF-4FAD-950E-BC9E49439DF0@richyen.com>
References: <ADDEA1D0-FEEF-4FAD-950E-BC9E49439DF0@richyen.com>
On Thu, Sep 06, 2007 at 09:06:53AM -0700, Richard Yen wrote:
>My understanding is that if any one postgres process's memory usage,
>plus the shared memory, exceeds the kernel limit of 4GB,
On a 32 bit system the per-process memory limit is a lot lower than 4G.
If you want to use 16G effectively it's going to be a lot easier to
simply use a 64bit system. That said, it's more likely that you've got a
number of processes using an aggregate of more than 16G than that you're
exceeding the limit per process. (Hitting the per-process limit should
result in a memory allocation failure rather than an out of memory
condition.)
Mike Stone
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: mstone+postgres@mathom.us
Subject: Re: postgres memory management issues?
In-Reply-To: <20070907101120.GF1795@mathom.us>
* 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