From: Robert Haas <robertmhaas@gmail.com>
To: Andy Colson <andy@squeakycode.net>
Cc: Rob <rclemley@yahoo.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: System overload / context switching / oom, 8.3
Date: Wed, 3 Feb 2010 15:40:56 -0500
Message-ID: <603c8f071002031240p2cd5ad38y691fcc8ecbbd4672@mail.gmail.com> (raw)
In-Reply-To: <4B688F76.9010002@squeakycode.net>
References: <4B6878DF.3000004@yahoo.com>
<4B688F76.9010002@squeakycode.net>
On Tue, Feb 2, 2010 at 3:47 PM, Andy Colson <andy@squeakycode.net> wrote:
>> effective_cache_size = 5000MB
>
> I see your running a 32bit, but with bigmem support, but still, one process
> is limited to 4gig. You'd make better use of all that ram if you switched
> to 64bit. And this cache, I think, would be limited to 4gig.
Just to be clear, effective_cache_size does not allocate any memory of
any kind, in any way, ever...
...Robert
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: robertmhaas@gmail.com, andy@squeakycode.net, rclemley@yahoo.com
Subject: Re: System overload / context switching / oom, 8.3
In-Reply-To: <603c8f071002031240p2cd5ad38y691fcc8ecbbd4672@mail.gmail.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