Re: upgrade from 9.2.x to 9.3 causes significant performance degradation

Поиск
Список
Период
Сортировка
От Kevin Grittner
Тема Re: upgrade from 9.2.x to 9.3 causes significant performance degradation
Дата
Msg-id 1379494979.65262.YahooMailNeo@web162904.mail.bf1.yahoo.com
обсуждение исходный текст
Ответ на Re: upgrade from 9.2.x to 9.3 causes significant performance degradation  (Lonni J Friedman <netllama@gmail.com>)
Ответы Re: upgrade from 9.2.x to 9.3 causes significant performance degradation  (Lonni J Friedman <netllama@gmail.com>)
Re: upgrade from 9.2.x to 9.3 causes significant performance degradation  (Lonni J Friedman <netllama@gmail.com>)
Список pgsql-general
Lonni J Friedman <netllama@gmail.com> wrote:

> top shows over 90% of the load is in sys space.  vmstat output
> seems to suggest that its CPU bound (or bouncing back & forth):

Can you run `perf top` during an episode and see what kernel
functions are using all that CPU?

This looks similar to cases I've seen of THP defrag going wild.
Did the OS version or configuration change?  Did the PostgreSQL
memory settings (like shared_buffers) change?

--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


В списке pgsql-general по дате отправления:

Предыдущее
От: Albe Laurenz
Дата:
Сообщение: Re: Cannot commit when autoCommit is enabled error
Следующее
От: Kevin Grittner
Дата:
Сообщение: Re: Cannot commit when autoCommit is enabled error