Re: [GENERAL] high load on server

2009-04-04 Thread Scott Marlowe
On Fri, Apr 3, 2009 at 4:13 PM, Erik Jones ejo...@engineyard.com wrote: Eh?  His run queue constantly has procs waiting for run time, although I've seen higher.  That with a distinct lack of heavy IO says cpu bound to me... I just pulled up the linux man page and it says that r is the number of

[GENERAL] high load on server

2009-04-03 Thread Gerd König
Hello, since 2 days ago we're facing an increased load on our database server (opensuse10.3-64bit, PostgreSQL 8.3.5, 8GB Ram). This high load stays the whole working day. == current situation: == #top top - 14:09:46 up 40 days, 8:08, 2 users, load average: 7.60,

Re: [GENERAL] high load on server

2009-04-03 Thread Scott Marlowe
2009/4/3 Gerd König koe...@transporeon.com: Hello, since 2 days ago we're facing an increased load on our database server (opensuse10.3-64bit, PostgreSQL 8.3.5, 8GB Ram). This high load stays the whole working day. How man cores? == current situation: ==

Re: [GENERAL] high load on server

2009-04-03 Thread Gerd Koenig
Hello Scott, thanks for answering. Scott Marlowe schrieb: 2009/4/3 Gerd König koe...@transporeon.com: Hello, since 2 days ago we're facing an increased load on our database server (opensuse10.3-64bit, PostgreSQL 8.3.5, 8GB Ram). This high load stays the whole working day. How man cores?

Re: [GENERAL] high load on server

2009-04-03 Thread Scott Marlowe
On Fri, Apr 3, 2009 at 12:35 PM, Gerd Koenig koe...@transporeon.com wrote: The problem might be that you're assuming there's a problem.  Looking at the rest of your diags, you're data set fits in memory, I/O wait is 10% and there are no processes waiting for a CPU to free up, they're all

Re: [GENERAL] high load on server

2009-04-03 Thread Erik Jones
On Apr 3, 2009, at 7:32 AM, Scott Marlowe wrote: 2009/4/3 Gerd König koe...@transporeon.com: Hello, since 2 days ago we're facing an increased load on our database server (opensuse10.3-64bit, PostgreSQL 8.3.5, 8GB Ram). This high load stays the whole working day. How man cores?

Re: [GENERAL] high load on server

2009-04-03 Thread Scott Marlowe
On Fri, Apr 3, 2009 at 4:13 PM, Erik Jones ejo...@engineyard.com wrote: On Apr 3, 2009, at 7:32 AM, Scott Marlowe wrote: 2009/4/3 Gerd König koe...@transporeon.com: Hello, since 2 days ago we're facing an increased load on our database server (opensuse10.3-64bit, PostgreSQL 8.3.5, 8GB