Re: postgresql.conf recommendations

Поиск
Список
Период
Сортировка
От Johnny Tan
Тема Re: postgresql.conf recommendations
Дата
Msg-id CABMVzL2GYAvWkBC=ik2s=D5=WT1qFWi9vVcsZpZSozSFLs1fng@mail.gmail.com
обсуждение исходный текст
Ответ на Re: postgresql.conf recommendations  (David Whittaker <dave@iradix.com>)
Список 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 по дате отправления:

Предыдущее
От: Johnny Tan
Дата:
Сообщение: Re: postgresql.conf recommendations
Следующее
От: Johnny Tan
Дата:
Сообщение: Re: postgresql.conf recommendations