Re: postgresql.conf recommendations - Mailing list pgsql-performance

From Johnny Tan
Subject Re: postgresql.conf recommendations
Date
Msg-id CABMVzL2GYAvWkBC=ik2s=D5=WT1qFWi9vVcsZpZSozSFLs1fng@mail.gmail.com
Whole thread Raw
In response to Re: postgresql.conf recommendations  (David Whittaker <dave@iradix.com>)
List pgsql-performance
On Wed, Feb 6, 2013 at 2:13 PM, David Whittaker <dave@iradix.com> 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:

johnny

pgsql-performance by date:

Previous
From: Johnny Tan
Date:
Subject: Re: postgresql.conf recommendations
Next
From: Johnny Tan
Date:
Subject: Re: postgresql.conf recommendations