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
