Re: PG 8.3 and server load - Mailing list pgsql-performance

From Tom Lane
Subject Re: PG 8.3 and server load
Date
Msg-id 23315.1250697761@sss.pgh.pa.us
Whole thread Raw
In response to Re: PG 8.3 and server load  (Phoenix Kiula <phoenix.kiula@gmail.com>)
List pgsql-performance
Phoenix Kiula <phoenix.kiula@gmail.com> writes:
> top - 10:38:53 up 29 days, 5 min,  1 user,  load average: 64.99, 65.17,
> 65.06
> Tasks: 568 total,   1 running, 537 sleeping,   6 stopped,  24 zombie
> Cpu0  : 17.7% us,  7.7% sy,  0.0% ni, 74.0% id,  0.7% wa,  0.0% hi,  0.0% si
> Cpu1  :  6.3% us,  5.6% sy,  0.0% ni, 84.4% id,  3.6% wa,  0.0% hi,  0.0% si
> Cpu2  :  5.6% us,  5.9% sy,  0.0% ni, 86.8% id,  1.7% wa,  0.0% hi,  0.0% si
> Cpu3  :  5.6% us,  4.0% sy,  0.0% ni, 74.2% id, 16.2% wa,  0.0% hi,  0.0% si
> Mem:   8310256k total,  8277416k used,    32840k free,    61944k buffers
> Swap:  2096440k total,    16128k used,  2080312k free,  7664224k cached

It sure looks from here like your box is not under any particular
stress.  The only thing that suggests a problem is the high load
average, but since that doesn't agree with any other measurements,
I'm inclined to think that the load average is simply wrong.
Do you have any actual evidence of a problem (like slow response)?

(I've seen load averages that had nothing to do with observable
reality on other Unixes, though not before on RHEL.)

            regards, tom lane

pgsql-performance by date:

Previous
From: Andy Colson
Date:
Subject: Re: PG 8.3 and server load
Next
From: Guillaume Cottenceau
Date:
Subject: Re: PG 8.3 and server load