Re: Adding more memory = hugh cpu load - Mailing list pgsql-performance

From Leonardo Francalanci
Subject Re: Adding more memory = hugh cpu load
Date
Msg-id 1318259675.10344.YahooMailNeo@web29011.mail.ird.yahoo.com
Whole thread Raw
In response to Re: Adding more memory = hugh cpu load  (Shaun Thomas <sthomas@peak6.com>)
Responses Re: Adding more memory = hugh cpu load  (Shaun Thomas <sthomas@peak6.com>)
List pgsql-performance

> That's not entirely surprising. The problem with having lots of memory is...
> that you have lots of memory. The operating system likes to cache, and this
> includes writes. Normally this isn't a problem, but with 48GB of RAM, the
> defaults (for CentOS 5.5 in particular) are to use up to 40% of that to cache
> writes.


I don't understand: don't you want postgresql to issue the fsync calls when
it "makes sense" (and configure them), rather than having the OS decide
when it's best to flush to disk? That is: don't you want all the memory to
be used for caching, unless postgresql says otherwise (calling fsync), instead
of "as soon as 1% of memory is used"?


pgsql-performance by date:

Previous
From: Shaun Thomas
Date:
Subject: Re: Adding more memory = hugh cpu load
Next
From: Shaun Thomas
Date:
Subject: Re: Adding more memory = hugh cpu load