Skip site navigation (1) Skip section navigation (2)

Re: High %SYS CPU usage

From: Cesar Martin <cmartinp(at)gmail(dot)com>
To: Josh Berkus <josh(at)agliodbs(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: High %SYS CPU usage
Date: 2012-11-02 07:47:42
Message-ID: CAMAsR=4a5e5U7hqBs-EfNwCtbDjM4qGDE1JF=11nEfNVODAoXg@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-performance
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

In response to

Responses

pgsql-performance by date

Next:From: Ants AasmaDate: 2012-11-02 11:27:40
Subject: Re: dbt2 performance regresses from 9.1.6 to 9.2.1
Previous:From: Scott MarloweDate: 2012-11-02 05:39:59
Subject: Re: Increasing work_mem and shared_buffers on Postgres 9.2 significantly slows down queries

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group