Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 22396632BCA for ; Wed, 2 Jun 2010 08:42:49 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 63080-04 for ; Wed, 2 Jun 2010 11:42:42 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from adslmx1.onecell.co.za (adslmx1.onecell.co.za [196.214.51.138]) by mail.postgresql.org (Postfix) with ESMTP id B5866632888 for ; Wed, 2 Jun 2010 08:42:38 -0300 (ADT) Received: from [192.168.21.54] [192.168.21.54] by aximail (Axigen) with ESMTP id 2CB944; Wed, 2 Jun 2010 13:37:28 +0200 Subject: Re: Overusing 1 CPU From: Mozzi To: Matthew Wakeling Cc: pgsql-performance@postgresql.org In-Reply-To: References: <1275477160.1818.48.camel@stefaans-laptop> Content-Type: text/plain; charset="UTF-8" Date: Wed, 02 Jun 2010 13:37:37 +0200 Message-ID: <1275478657.1818.53.camel@stefaans-laptop> Mime-Version: 1.0 X-Mailer: Evolution 2.28.3 Content-Transfer-Encoding: 7bit X-AxigenSpam-Level: 4 X-AxigenVirus-Level: 1 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-0.001 tagged_above=-10 required=5 tests=BAYES_20=-0.001 X-Spam-Level: X-Archive-Number: 201006/21 X-Sequence-Number: 38877 Hi Thanx mate Create Index seems to be the culprit. Is it normal to just use 1 cpu tho? Mozzi On Wed, 2010-06-02 at 12:24 +0100, Matthew Wakeling wrote: > On Wed, 2 Jun 2010, Mozzi wrote: > > This box is basically adle @ the moment as it is still in testing yet > > top shows high usage on just 1 of the cores. > > First port of call: What process is using the CPU? Run top on a fairly > wide terminal and use the "c" button to show the full command line. > > Matthew >