Re: High %SYS CPU usage

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: High %SYS CPU usage
Date: 2012-10-30 19:07:37
Message-ID: 50902579.5090304@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Petr Praus 2012-10-30 19:08:56 Increasing work_mem and shared_buffers on Postgres 9.2 significantly slows down queries
Previous Message pg noob 2012-10-30 18:34:31 pg_buffercache