Re: High %SYS CPU usage

Finally I resolv the problem
setting /sys/kernel/mm/redhat_transparent_hugepage/enabled to "never"

2012/11/2 Cesar Martin <cmartinp(at)gmail(dot)com>

> Hi Josh,
>
> Today is not the worse day for this issue, because Fridays DB have little
> workload... But I have this output:
>
> http://pastebin.com/bKg8tfKC
>
> I don't have updated OS server from the install.
> I also begin to think that the problem is OS misconfiguration (Kernel
> parameters??) or Hardware problem...
>
> Thanks for your help.
>
>
> 2012/10/30 Josh Berkus <josh(at)agliodbs(dot)com>
>
>> Cesar,
>>
>> > On this server I have only one database with 312GB of data. The database
>> > had run fine during 4 months, but from two months ago, during high work
>> > load periods, the server is collapsed by "%sys" type load.
>>
>> Hmmm. Have you updated Linux any time recently? I'm wondering if this
>> is a PostgreSQL problem at all. It sounds like an OS issue.
>>
>> Can you give us the results of mpstat -P ALL 3 ? The dstat output
>> doesn't tell me much.
>>
>> --
>> Josh Berkus
>> PostgreSQL Experts Inc.
>> http://pgexperts.com
>>
>>
>> --
>> Sent via pgsql-performance mailing list (pgsql-performance(at)postgresql(dot)org
>> )
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-performance
>>
>
>
>
> --
> César Martín Pérez
> cmartinp(at)gmail(dot)com
>
>

--
César Martín Pérez
cmartinp(at)gmail(dot)com