X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 53701D9422 for ; Tue, 22 Nov 2005 12:50:38 -0400 (AST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 76200-03 for ; Tue, 22 Nov 2005 16:50:36 +0000 (GMT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from frank.wiles.org (frank.wiles.org [24.124.39.75]) by svr1.postgresql.org (Postfix) with ESMTP id 06CE7D86C2 for ; Tue, 22 Nov 2005 12:50:34 -0400 (AST) Received: from kungfu (frank.wiles.org [127.0.0.1]) by frank.wiles.org (8.13.1/8.13.1) with SMTP id jAMGoNEL014106; Tue, 22 Nov 2005 10:50:23 -0600 Date: Tue, 22 Nov 2005 10:51:00 -0600 From: Frank Wiles To: Marek Dabrowski Cc: pgsql-performance@postgresql.org Subject: Re: System queue Message-Id: <20051122105100.57e8b60d.frank@wiles.org> In-Reply-To: <438329C3.9060603@infor.pl> References: <438329C3.9060603@infor.pl> X-Mailer: Sylpheed version 2.0.1 (GTK+ 2.6.10; i686-pc-linux-gnu) Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0 required=5 tests=[none] X-Spam-Score: 0 X-Spam-Level: X-Archive-Number: 200511/444 X-Sequence-Number: 15701 On Tue, 22 Nov 2005 15:22:59 +0100 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? 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 http://www.wiles.org ---------------------------------