Re: [PERFORM] Tuning Effective Cache Question

2005-08-17 Thread Josh Berkus
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 an

Re: [PERFORM] Tuning Effective Cache Question

2005-08-17 Thread Chris Hoover
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 postgr

[PERFORM] Tuning Effective Cache Question

2005-08-17 Thread Chris Hoover
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 tel