pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedTuning Effective Cache Question
3+ messages / 2 participants
[nested] [flat]
* Tuning Effective Cache Question
@ 2005-08-17 17:14 Chris Hoover <revoohc@gmail.com>
0 siblings, 2 replies; 3+ messages in thread
From: Chris Hoover @ 2005-08-17 17:14 UTC (permalink / raw)
To: pgsql-performance
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Tuning Effective Cache Question
@ 2005-08-17 17:17 Chris Hoover <revoohc@gmail.com>
parent: Chris Hoover <revoohc@gmail.com>
1 sibling, 0 replies; 3+ messages in thread
From: Chris Hoover @ 2005-08-17 17:17 UTC (permalink / raw)
To: pgsql-performance
Sorry, forgot to state that we are still on PG 7.3.4.
On 8/17/05, Chris Hoover <revoohc@gmail.com> 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
>
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Tuning Effective Cache Question
@ 2005-08-17 20:31 Josh Berkus <josh@agliodbs.com>
parent: Chris Hoover <revoohc@gmail.com>
1 sibling, 0 replies; 3+ messages in thread
From: Josh Berkus @ 2005-08-17 20:31 UTC (permalink / raw)
To: pgsql-performance; +Cc: Chris Hoover <revoohc@gmail.com>
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
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2005-08-17 20:31 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-08-17 17:14 Tuning Effective Cache Question Chris Hoover <revoohc@gmail.com>
2005-08-17 17:17 ` Chris Hoover <revoohc@gmail.com>
2005-08-17 20:31 ` Josh Berkus <josh@agliodbs.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox