pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedSystem queue
3+ messages / 3 participants
[nested] [flat]
* System queue
@ 2005-11-22 14:22 Marek Dabrowski <marek.dabrowski@infor.pl>
0 siblings, 2 replies; 3+ messages in thread
From: Marek Dabrowski @ 2005-11-22 14:22 UTC (permalink / raw)
To: 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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: System queue
@ 2005-11-22 16:51 Frank Wiles <frank@wiles.org>
parent: Marek Dabrowski <marek.dabrowski@infor.pl>
1 sibling, 0 replies; 3+ messages in thread
From: Frank Wiles @ 2005-11-22 16:51 UTC (permalink / raw)
To: Marek Dabrowski <marek.dabrowski@infor.pl>; +Cc: pgsql-performance
On Tue, 22 Nov 2005 15:22:59 +0100
Marek Dabrowski <marek.dabrowski@infor.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@wiles.org>
http://www.wiles.org
---------------------------------
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: System queue
@ 2005-11-22 17:28 Jeff Trout <threshar@torgo.978.org>
parent: Marek Dabrowski <marek.dabrowski@infor.pl>
1 sibling, 0 replies; 3+ messages in thread
From: Jeff Trout @ 2005-11-22 17:28 UTC (permalink / raw)
To: Marek Dabrowski <marek.dabrowski@infor.pl>; +Cc: 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@jefftrout.com>
http://www.jefftrout.com/
http://www.stuarthamm.net/
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2005-11-22 17:28 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-11-22 14:22 System queue Marek Dabrowski <marek.dabrowski@infor.pl>
2005-11-22 16:51 ` Frank Wiles <frank@wiles.org>
2005-11-22 17:28 ` Jeff Trout <threshar@torgo.978.org>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox