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: (view raw or whole 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  

Jeff Trout <jeff(at)jefftrout(dot)com>

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-2015 The PostgreSQL Global Development Group