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
---------------------------------
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 |