Re: [PERFORM] High %SYS CPU usage

2012-12-31 Thread Cesar Martin
Finally I resolv the problem setting /sys/kernel/mm/redhat_transparent_hugepage/enabled to never 2012/11/2 Cesar Martin cmart...@gmail.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

Re: [PERFORM] High %SYS CPU usage

2012-11-02 Thread Cesar Martin
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

[PERFORM] High %SYS CPU usage

2012-10-30 Thread Cesar Martin
Hello there, I have PostgreSQL 8.3.18 server running on Centos 6.2 (2.6.32-220.7.1) with this specs: 2x CPU AMD Opteron 6282 128GB RAM Raid 10 (12HD 15k rpm 1GB cache) with data Raid 10 (4HD 15k rpm 1GB cache) with xlog Raid 1 (15k rpm 1GB cache shared with xlog) with system On this server I

Re: [PERFORM] High %SYS CPU usage

2012-10-30 Thread Josh Berkus
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