Re: postgresql.conf recommendations

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Wed, Feb 6, 2013 at 2:13 PM, David Whittaker <dave@xxxxxxxxxx> wrote:
We disabled THP all together, with the thought that we might re-enable without defrag if we got positive results.  At this point I don't think THP is the root cause though, so I'm curious to see if anyone else gets positive results from disabling it.  We definitely haven't seen any performance hit from turning it off.

We are considering disabling THP, although we aren't seeing the errors in syslog that David mentioned.

Josh: What made you think of THP? I'm curious if there's a discussion you can point me to. Since you mentioned it, I've been looking more into it, and there isn't too much. In fact, this post makes it sound like enabling it fixes a similar problem to what we're seeing -- i.e., %system shoots up during the spikes:
http://www.pythian.com/blog/performance-tuning-hugepages-in-linux/

johnny

[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux