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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-performance by date

  From Date Subject
Next Message Guillaume Cottenceau 2009-08-19 16:08:20 Re: PG 8.3 and server load
Previous Message Andy Colson 2009-08-19 15:52:40 Re: PG 8.3 and server load