Re: System queue

From: Jeff Trout <threshar(at)torgo(dot)978(dot)org>
To: Marek Dabrowski <marek(dot)dabrowski(at)infor(dot)pl>
Cc: Pgsql-Performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: System queue
Date: 2005-11-22 17:28:00
Message-ID: E09D46F0-6DFC-4410-A00D-CA5301A88CF3@torgo.978.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance


On Nov 22, 2005, at 9:22 AM, Marek Dabrowski wrote:

> Hello
>
> On my serwer Linux Fedora, HP DL360G3 with 2x3.06 GHz 4GB RAM
> working postgresql 7.4.6. Cpu utilization is about 40-50% but
> system process queue is long - about 6 task. Do you have nay
> sugestion/solution?\

High run queue (loadavg) with low cpu usage means you are IO bound.
Either change some queries around to generate less IO, or add more
disks.

--
Jeff Trout <jeff(at)jefftrout(dot)com>
http://www.jefftrout.com/
http://www.stuarthamm.net/

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2005-11-22 17:35:49 Re: High context switches occurring
Previous Message Ron 2005-11-22 17:19:57 Re: weird performances problem