|
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/ Managing Director: Ralf Reichert Register Court: Local Court Cologne, HRB
36678 |
