Re: System overload / context switching / oom, 8.3 - Mailing list pgsql-performance

From Robert Haas
Subject Re: System overload / context switching / oom, 8.3
Date
Msg-id 603c8f071002031240p2cd5ad38y691fcc8ecbbd4672@mail.gmail.com
Whole thread Raw
In response to Re: System overload / context switching / oom, 8.3  (Andy Colson <andy@squeakycode.net>)
List pgsql-performance
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

pgsql-performance by date:

Previous
From: Mridula Mahadevan
Date:
Subject: Re: Queries within a function
Next
From: Robert Haas
Date:
Subject: Re: Optimizing Postgresql server and FreeBSD for heavy read and writes