Re: high load on server - Mailing list pgsql-general

From Scott Marlowe
Subject Re: high load on server
Date
Msg-id dcc563d10904040416n38b65529u104518b37746ac4c@mail.gmail.com
Whole thread Raw
In response to Re: high load on server  (Erik Jones <ejones@engineyard.com>)
List pgsql-general
On Fri, Apr 3, 2009 at 4:13 PM, Erik Jones <ejones@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 processes waiting to run.  This isn't entirely correct.  A BSD or
Solaris man page more correctly identifies it as the number of
processes running OR waiting to run and that if this number exceeds
the number of cores then the number by which is exceeds it is how big
of a queue there is.

pgsql-general by date:

Previous
From: c k
Date:
Subject: strange behavior of plpgsql function
Next
From: Piotr Buczek
Date:
Subject: deadlock in trigger before insert