From: Frank Wiles <frank@wiles.org>
To: Marek Dabrowski <marek.dabrowski@infor.pl>
Cc: pgsql-performance@postgresql.org
Subject: Re: System queue
Date: Tue, 22 Nov 2005 10:51:00 -0600
Message-ID: <20051122105100.57e8b60d.frank@wiles.org> (raw)
In-Reply-To: <438329C3.9060603@infor.pl>
References: <438329C3.9060603@infor.pl>
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
---------------------------------
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: frank@wiles.org, marek.dabrowski@infor.pl
Subject: Re: System queue
In-Reply-To: <20051122105100.57e8b60d.frank@wiles.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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