Re: System queue - Mailing list pgsql-performance

From Jeff Trout
Subject Re: System queue
Date
Msg-id E09D46F0-6DFC-4410-A00D-CA5301A88CF3@torgo.978.org
Whole thread Raw
In response to System queue  (Marek Dabrowski <marek.dabrowski@infor.pl>)
List 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@jefftrout.com>
http://www.jefftrout.com/
http://www.stuarthamm.net/



pgsql-performance by date:

Previous
From: Ron
Date:
Subject: Re: weird performances problem
Next
From: Tom Lane
Date:
Subject: Re: High context switches occurring