high user cpu, massive SELECTs, no io waiting problem - Mailing list pgsql-performance

From Thomas Pöhler
Subject high user cpu, massive SELECTs, no io waiting problem
Date
Msg-id F1CD4AC5B4A5024AAB60E28A82A8450A03CEB0C7@winexch1.office.turtle-entertainment.de
Whole thread Raw
Responses Re: high user cpu, massive SELECTs, no io waiting problem  (Scott Marlowe <scott.marlowe@gmail.com>)
Re: high user cpu, massive SELECTs, no io waiting problem  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Re: high user cpu, massive SELECTs, no io waiting problem  ("Strange, John W" <john.w.strange@jpmchase.com>)
Re: high user cpu, massive SELECTs, no io waiting problem  (marcin mank <marcin.mank@gmail.com>)
Re: high user cpu, massive SELECTs, no io waiting problem  (Ivan Voras <ivoras@freebsd.org>)
List pgsql-performance

Hi list,

 

first time for me here, hope you’re not dealing too severely with me regarding guidelines. Giving my best.

 

We are running PostgreSQL 8.4.4 on x86_64-unknown-linux-gnu, compiled by GCC gcc (Debian 4.3.2-1.1) 4.3.2, 64-bit on a Supermicro SuperServer 8026B-6RF.

This version is downloaded from postgresql.org and selfcompiled, running for over a year now. The Server has 128 GB RAM and Four Intel® Xeon® X7550 with 64 logical cores.

Operating System is “Linux database1 2.6.32-bpo.5-amd64 #1 SMP Mon Dec 13 17:10:39 UTC 2010 x86_64 GNU/Linux”.

 

The System boots through iscsi over a Qlogic QLE4062C HBA. Pgdata and xlog is logged in over iscsi HBA too. We tried en and disabling jumbo frames. Makes no difference.

We are using a DELL Equallogic SAN Backend with SAS drives.

 

Postgres is used as  backend for a high performance website. We are using nginx with php-fastcgi and memcached.

 

Since a few weeks we have really strange peaks on this system. User CPU is increasing up to 100% and we have lots of SELECTs running.

There is no iowait at this time, only high user cpu and we don’t know where this is coming from. It seems like this is only happening under certain circumstances.

 

We can solve this problem by simply removing the load from the website by delivering an offline page. We let database calm down for a while and then slowly throttling users.

 

See ganglia: http://dl.dropbox.com/u/183323/CPUloadprobsdb1.jpg

 

Has someone made similar experiences? Perhaps there is some issue between Postgres 8.4.4 and kernel 2.6.32?

 

Thank in advance

Thomas

 

 

 

--

Turtle Entertainment GmbH

Thomas Pöhler, Manager IT Operations

Siegburger Str. 189

50679 Cologne

Germany

fon. +49 221 880449-331

fax. +49 221 880449-399

http://www.turtle-entertainment.com/

http://www.esl.eu/

http://www.consoles.net/

Managing Director: Ralf Reichert

Register Court: Local Court Cologne, HRB 36678

 

pgsql-performance by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: Checkpointing question
Next
From: Scott Marlowe
Date:
Subject: Re: high user cpu, massive SELECTs, no io waiting problem