Re: Performance on SUSE w/ reiserfs - Mailing list pgsql-performance

From Alvaro Herrera
Subject Re: Performance on SUSE w/ reiserfs
Date
Msg-id 20051010222937.GL5848@surnet.cl
Whole thread Raw
In response to Re: Performance on SUSE w/ reiserfs  (Jon Brisbin <jon.brisbin@npcinternational.com>)
List pgsql-performance
Jon Brisbin wrote:
> Tom Lane wrote:
> >
> >Are you sure it's not cached data pages, rather than cached inodes?
> >If so, the above behavior is *good*.
> >
> >People often have a mistaken notion that having near-zero free RAM means
> >they have a problem.  In point of fact, that is the way it is supposed
> >to be (at least on Unix-like systems).  This is just a reflection of the
> >kernel doing what it is supposed to do, which is to use all spare RAM
> >for caching recently accessed disk pages.  If you're not swapping then
> >you do not have a problem.
>
> Except for the fact that my Java App server crashes when all the
> available memory is being used by caching and not reclaimed :-)

Ah, so you have a different problem.  What you should be asking is why
the appserver crashes.  You still seem to have a lot of free swap,
judging by a nearby post.  But maybe the problem is that the swap is
completely used too, and so the OOM killer (is this Linux?) comes around
and kills the appserver.

Certainly the problem is not the caching.  You should be monitoring when
and why the appserver dies.

--
Alvaro Herrera                         Architect, http://www.EnterpriseDB.com
"On the other flipper, one wrong move and we're Fatal Exceptions"
(T.U.X.: Term Unit X  - http://www.thelinuxreview.com/TUX/)

pgsql-performance by date:

Previous
From: Steve Poe
Date:
Subject: XFS External Log on Pg 7.4.8 Pg_xlog drives?
Next
From: Tom Lane
Date:
Subject: Re: Performance on SUSE w/ reiserfs