Re: Configuration Recommendations - Mailing list pgsql-performance

From Jan Nielsen
Subject Re: Configuration Recommendations
Date
Msg-id CANxH4hG3OOuQeBspcCdakxN61dr0rNs251zdtO3VWHpMPjwZMw@mail.gmail.com
Whole thread Raw
In response to Configuration Recommendations  (Jan Nielsen <jan.sture.nielsen@gmail.com>)
Responses Re: Configuration Recommendations  (Shaun Thomas <sthomas@optionshouse.com>)
List 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 by date:

Previous
From: Jan Nielsen
Date:
Subject: Re: Configuration Recommendations
Next
From: Merlin Moncure
Date:
Subject: Re: scale up (postgresql vs mssql)