Sorry, forgot to state that we are still on PG 7.3.4.

On 8/17/05, Chris Hoover <[EMAIL PROTECTED]> wrote:
> I have some questions about tuning my effective_cache_size
> 
> 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.
> 
> Here are the exact numbers:
> Mem:  7720040K av, 7714364K used,    5676K free,  314816K shrd, 3737540K buff
> Swap: 2096440K av,  119448K used, 1976992K free                 3188192K 
> cached
> 
> 
> 1.  Is the configuration that linux is running in hurting PostgreSQL in any 
> way?
> 
> 2.  Is there a negative impact of the effective_cache_size being
> larger than the actual cached memory?
> 
> 3.  What effect postive or negative does the buff memory have on PostgreSQL.\
> 
> 4.  What exactly is this buff memory used for?  We have had a time
> trying to find a good explanation of what it means.
> 
> Overall, this system appears to be running fine.  However, I was taken
> back when I saw the current memory configuration.  We have been
> walking a fine line performance wise, and can quickly become i/o
> starved.  So I want to make sure that I am not pushing the db towards
> the i/o starved side.
> 
> Thanks for any insight,
> 
> Chris
>

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faq

Reply via email to