| Lists: | pgsql-performance |
|---|
| From: | Marek Dabrowski <marek(dot)dabrowski(at)infor(dot)pl> |
|---|---|
| To: | Pgsql-Performance <pgsql-performance(at)postgresql(dot)org> |
| Subject: | System queue |
| Date: | 2005-11-22 14:22:59 |
| Message-ID: | 438329C3.9060603@infor.pl |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-performance |
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?
Regards
Marek
| 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 |
| 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: | 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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/