Re: System overload / context switching / oom, 8.3

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: Andy Colson <andy(at)squeakycode(dot)net>
Cc: Rob <rclemley(at)yahoo(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: System overload / context switching / oom, 8.3
Date: 2010-02-03 20:40:56
Message-ID: 603c8f071002031240p2cd5ad38y691fcc8ecbbd4672@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Tue, Feb 2, 2010 at 3:47 PM, Andy Colson <andy(at)squeakycode(dot)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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Robert Haas 2010-02-03 20:43:50 Re: Optimizing Postgresql server and FreeBSD for heavy read and writes
Previous Message Mridula Mahadevan 2010-02-03 20:06:12 Re: Queries within a function