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

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 (view raw or flat)
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

pgsql-performance by date

Next:From: Tom LaneDate: 2005-11-22 17:35:49
Subject: Re: High context switches occurring
Previous:From: RonDate: 2005-11-22 17:19:57
Subject: Re: weird performances problem

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