Re: System queue

From: Frank Wiles <frank(at)wiles(dot)org>
To: Marek Dabrowski <marek(dot)dabrowski(at)infor(dot)pl>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: System queue
Date: 2005-11-22 16:51:00
Message-ID: 20051122105100.57e8b60d.frank@wiles.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Tue, 22 Nov 2005 15:22:59 +0100
Marek Dabrowski <marek(dot)dabrowski(at)infor(dot)pl> 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?

We're going to need a lot more information than that to diagnose what
is going on. Do you have any functions or queries that will need to
use a large amount of CPU?

In general I would suggest upgrading to the latest Fedora and moving
to PostgreSQL 8.x. Doing this will get you some extra performance,
but will probably not entirely solve your problem.

---------------------------------
Frank Wiles <frank(at)wiles(dot)org>
http://www.wiles.org
---------------------------------

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Anjan Dave 2005-11-22 16:59:54 High context switches occurring
Previous Message Guillaume Smet 2005-11-22 15:26:17 Re: weird performances problem