Re: Configuration Recommendations

Поиск
Список
Период
Сортировка
От Jan Nielsen
Тема Re: Configuration Recommendations
Дата
Msg-id CANxH4hG3OOuQeBspcCdakxN61dr0rNs251zdtO3VWHpMPjwZMw@mail.gmail.com
обсуждение исходный текст
Ответ на Configuration Recommendations  (Jan Nielsen <jan.sture.nielsen@gmail.com>)
Ответы Re: Configuration Recommendations  (Shaun Thomas <sthomas@optionshouse.com>)
Список pgsql-performance


On Thu, May 3, 2012 at 7:05 AM, Shaun Thomas <sthomas@optionshouse.com> wrote:
I like to follow this:

http://www.westnet.com/~gsmith/content/linux-pdflush.htm

Thanks for the reference, Shaun.
 
As a note, there are actually new tunables for some of this: dirty_bytes, and dirty_background_bytes. With them, you can match them better to the actual size of your controller write cache so you can avoid page flush storms causing IO stalls.

That sounds interesting. How do you identify a page flush storm?
 
Mr. Nielsen's setup actually looks pretty darn good. It's my personal opinion he might run into some IO waits if he plans to use this for heavy OLTP, thanks to having only 8 spindles in his RAID1+0, but he may eventually grow into a SAN. That's fine. It's a good starting point.

Cool - thanks, again, for the review, Shaun.


Cheers,

Jan

 


--
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 по дате отправления:

Предыдущее
От: Jan Nielsen
Дата:
Сообщение: Re: Configuration Recommendations
Следующее
От: Merlin Moncure
Дата:
Сообщение: Re: scale up (postgresql vs mssql)