Re: Tuning Effective Cache Question - Mailing list pgsql-performance

From Josh Berkus
Subject Re: Tuning Effective Cache Question
Date
Msg-id 200508171331.38980.josh@agliodbs.com
Whole thread Raw
In response to Tuning Effective Cache Question  (Chris Hoover <revoohc@gmail.com>)
List pgsql-performance
Chris,

> I have a RHEL 2.1 box running with dual Xeon (2.6 GHz I believe and
> they have HT on).  The box has 8GB memory.  In my postgresql.conf, I
> have set the effective_cache_size = 530505 (~4GB).
>
> However, I am noticing on this machine, top is telling me that I have
> ~3.5GB in the buff and only 3GB in cached.

effective_cache_size is just information for the query planner; it does not
affect the actually system file cache.

--
--Josh

Josh Berkus
Aglio Database Solutions
San Francisco

pgsql-performance by date:

Previous
From: Matthew Nuzum
Date:
Subject: Re: Need for speed
Next
From: Manfred Koizar
Date:
Subject: Re: Insert performance (OT?)