Re: Tuning Effective Cache Question

Поиск
Список
Период
Сортировка
От Josh Berkus
Тема Re: Tuning Effective Cache Question
Дата
Msg-id 200508171331.38980.josh@agliodbs.com
обсуждение исходный текст
Ответ на Tuning Effective Cache Question  (Chris Hoover <revoohc@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Matthew Nuzum
Дата:
Сообщение: Re: Need for speed
Следующее
От: Manfred Koizar
Дата:
Сообщение: Re: Insert performance (OT?)