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 > > 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 <j...@agliodbs.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@postgresql.org >> ) >> To make changes to your subscription: >> http://www.postgresql.org/mailpref/pgsql-performance >> > > > > -- > César Martín Pérez > cmart...@gmail.com > > -- César Martín Pérez cmart...@gmail.com
