Re: shared_buffers/effective_cache_size on 96GB server

Поиск
Список
Период
Сортировка
От Shaun Thomas
Тема Re: shared_buffers/effective_cache_size on 96GB server
Дата
Msg-id 50758857.6030008@optionshouse.com
обсуждение исходный текст
Ответ на Re: shared_buffers/effective_cache_size on 96GB server  (Strahinja Kustudić <strahinjak@nordeus.com>)
Ответы Re: shared_buffers/effective_cache_size on 96GB server  (Strahinja Kustudić <strahinjak@nordeus.com>)
Список pgsql-performance
On 10/10/2012 09:35 AM, Strahinja Kustudić wrote:

> #sysctl vm.dirty_ratio
> vm.dirty_ratio = 40
> # sysctl vm.dirty_background_ratio
> vm.dirty_background_ratio = 10

Ouuuuch. That looks a lot like an old RHEL or CentOS system. Change
those ASAP. Currently your system won't start writing dirty buffers
until it hits 9.6GB. :(

> shows that these values are even higher by default. When you said
> RAID buffer size, you meant the controllers cache memory size?

Yeah, that. :)

--
Shaun Thomas
OptionsHouse | 141 W. Jackson Blvd. | Suite 500 | Chicago IL, 60604
312-444-8534
sthomas@optionshouse.com

______________________________________________

See http://www.peak6.com/email_disclaimer/ for terms and conditions related to this email


В списке pgsql-performance по дате отправления:

Предыдущее
От: Strahinja Kustudić
Дата:
Сообщение: Re: shared_buffers/effective_cache_size on 96GB server
Следующее
От: Claudio Freire
Дата:
Сообщение: Re: Hyperthreading (was: Two identical systems, radically different performance)