Skip site navigation (1) Skip section navigation (2)

Re: PG 8.3 and server load

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Phoenix Kiula <phoenix(dot)kiula(at)gmail(dot)com>
Cc: Andy Colson <andy(at)squeakycode(dot)net>, Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>, pgsql-performance(at)postgresql(dot)org
Subject: Re: PG 8.3 and server load
Date: 2009-08-19 16:02:41
Message-ID: 23315.1250697761@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-performance
Phoenix Kiula <phoenix(dot)kiula(at)gmail(dot)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

In response to

pgsql-performance by date

Next:From: Guillaume CottenceauDate: 2009-08-19 16:08:20
Subject: Re: PG 8.3 and server load
Previous:From: Andy ColsonDate: 2009-08-19 15:52:40
Subject: Re: PG 8.3 and server load

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group