Re: Tuning Effective Cache Question

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Cc: Chris Hoover <revoohc(at)gmail(dot)com>
Subject: Re: Tuning Effective Cache Question
Date: 2005-08-17 20:31:38
Message-ID: 200508171331.38980.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Matthew Nuzum 2005-08-17 20:33:52 Re: Need for speed
Previous Message Manfred Koizar 2005-08-17 20:25:09 Re: Insert performance (OT?)